Installing MSDE 2000a

I have downloaded MSDE 2000a and installed it from the run command on Windows
XP SP2 but can only connect with the login "Trusted NT connection" and not
with the sa login. Can someone please give me the correct command to type to
install with sql or mixed authentication.
http://support.microsoft.com/default...b;en-us;319930
look at the heading "Enable Mixed Mode Authentication After Installation"
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"cwsjnr" wrote:

> I have downloaded MSDE 2000a and installed it from the run command on Windows
> XP SP2 but can only connect with the login "Trusted NT connection" and not
> with the sa login. Can someone please give me the correct command to type to
> install with sql or mixed authentication.

installation steps

hi !!!
i try to connect to my sql server local instance but it is always failed .... can you please tell me the step by steps and options to use to install sql server on my machine and i think i need to use he personal copy rather than the standard as it will be on my machne not in the server? please helpThe way I install SQL Server and any other database on Windows, I don't answer questions Windows ask me during installation because Windows does not know RDBMS and all your installation will complete. So you answer one or two relevant questions and you can install even Oracle. Hope this helps|||

thanks for reply .... but there is a reply to those questions in choosing options.... can you tell me in each step what shal i choose ?

|||When you are asked what option don't choose custom and the only other question that is relevant to you is the account to use to install and being a developer use the local system account and you can install the personal in less than five minutes. When you answer questions Windows checks those against what is in its database and end your installation. Hope this helps.|||let me expalin toyou the problem...i have machine at work i installed sql server before it was fine ...i did the same thing in my machine at home it does not work ..i can nto connect to the database.... can you please help i try connectionstrings.com and i tried different things still does not work .. please help !!|||In Visual Studio use the datalink property and use integrated security, all the answers I have been giving you are to install the database. And post your error so it can be investigated. Hope this helps.|||Hi,
fadil, whichs the OS on which ur trying to install the sql server?
just go thru this ,
http://www.functionx.com/sql/Lesson01.htm
hope this works..
all the best

Installation problem

I have installed SQL Server Express Edition using SQLServer2005_SSMSEE.msi.
All was fine.
But, when I managed to connect to the server when
I choosed <browse for more ...> in the server name combo
the application was unable to find a server (either local or remote. I think that the server should be a local one if I installed it locally on the machine).
I tried many combinations for the server name based on the machine and domain name:

MACHINE
MACHINE\MACHINE
DOMAIN\MACHINE

but all the times the following error occured:
TITLE: New Server Registration

Testing the registered server failed. Verify the server name, login credentials, and database, and then click Test again.

ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

BUTTONS:

OK
Can anyone help me to register a server?

Thanks,

Radu

Hi.

Try " (local)\SQLEXPRESS"

The default instant name of Sql Server 2005 Express Edition is SQLEXPRESS (case-insensitive)

".\SQLEXPRESS" Will work if you have TCP/IP access enabled (See your SQL Server service manager)

MACHINE\SQLEXPRESS should work too.

Hope this helps

|||

I having issues with SQL Express remote issues, I have turned remote on in the area configuration and enabled all protocols.

MachineName/SQLEXPRESS on remote machines worked for about a day and than on remote machines in the network no longer can use the Management tool to see SQL engine. I checked and the MachineName/SQLEXPRESS is definitely registered.

Everything seems to work as expected on the local machine. The puzzeling thing is it did work for about a day and nothing changes on the network.

Any help would be very appreciated

Installation problem

I have installed SQL Server Express Edition using SQLServer2005_SSMSEE.msi.
All was fine.
But, when I managed to connect to the server when
I choosed <browse for more ...> in the server name combo
the application was unable to find a server (either local or remote. I think that the server should be a local one if I installed it locally on the machine).
I tried many combinations for the server name based on the machine and domain name:

MACHINE
MACHINE\MACHINE
DOMAIN\MACHINE

but all the times the following error occured:
TITLE: New Server Registration

Testing the registered server failed. Verify the server name, login credentials, and database, and then click Test again.

ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

BUTTONS:

OK
Can anyone help me to register a server?

Thanks,

Radu

Hi.

Try " (local)\SQLEXPRESS"

The default instant name of Sql Server 2005 Express Edition is SQLEXPRESS (case-insensitive)

".\SQLEXPRESS" Will work if you have TCP/IP access enabled (See your SQL Server service manager)

MACHINE\SQLEXPRESS should work too.

Hope this helps

|||

I having issues with SQL Express remote issues, I have turned remote on in the area configuration and enabled all protocols.

MachineName/SQLEXPRESS on remote machines worked for about a day and than on remote machines in the network no longer can use the Management tool to see SQL engine. I checked and the MachineName/SQLEXPRESS is definitely registered.

Everything seems to work as expected on the local machine. The puzzeling thing is it did work for about a day and nothing changes on the network.

Any help would be very appreciated