not able to connect with sql server2000
-
hi my friend has installed sql server2000 with windows authentication. now he is finding problem in doing connectivity with it.what to be do.Is he has have to reinstalled it or is there some other method to do the connectivity.well do reply soon. the error is something like "Illegal sql server authentication". thanks in advance.:-D nauty
-
hi my friend has installed sql server2000 with windows authentication. now he is finding problem in doing connectivity with it.what to be do.Is he has have to reinstalled it or is there some other method to do the connectivity.well do reply soon. the error is something like "Illegal sql server authentication". thanks in advance.:-D nauty
nauty wrote:
now he is finding problem in doing connectivity with it
Can you explain detail about the problem or the description of the message box? Let do this case but you need to run on windows xp pro or win2k pro: 1. Log on as administrator mode. 2. Install sql server 2000. 3. Install MSDE 2000. MSDE could obtain from Microsoft download center.[^] 4. Open your sql server 2000 via Enterprise manager shortcut command in Microsoft sql server program folder. 5. Check the connection string.[^]
-
nauty wrote:
now he is finding problem in doing connectivity with it
Can you explain detail about the problem or the description of the message box? Let do this case but you need to run on windows xp pro or win2k pro: 1. Log on as administrator mode. 2. Install sql server 2000. 3. Install MSDE 2000. MSDE could obtain from Microsoft download center.[^] 4. Open your sql server 2000 via Enterprise manager shortcut command in Microsoft sql server program folder. 5. Check the connection string.[^]
Roath Kanel wrote:
3. Install MSDE 2000. MSDE could obtain from Microsoft download center.[^]
WHAT???? Why? SQL Server is already installed! RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
-
Roath Kanel wrote:
3. Install MSDE 2000. MSDE could obtain from Microsoft download center.[^]
WHAT???? Why? SQL Server is already installed! RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
I used to install sql server 2000 on windows xp pro. Whether sql server is running but i could not access to database. I also could not find server registration. But after i install MSDE from office xp pro CDROM. Then i could be able to access to database.
-
I used to install sql server 2000 on windows xp pro. Whether sql server is running but i could not access to database. I also could not find server registration. But after i install MSDE from office xp pro CDROM. Then i could be able to access to database.
Hmmm... I had no problem at all. Limited number of connections due to XP's licensing limits, but it works fine, without using MSDE. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
-
Hmmm... I had no problem at all. Limited number of connections due to XP's licensing limits, but it works fine, without using MSDE. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
Dave, I will e-mail to you with attachment which show you about the problem since the time that i used to install sql 2000 before. I also wonder about the problem too but never post the question to the forum because i could run sql after i install msde. The attachment will include the screenshot to explain about each step.