Showing posts with label control. Show all posts
Showing posts with label control. Show all posts

Friday, March 23, 2012

MSDE Problem - SQL Server not found or access denied

I am running the MSDE 2000 Setup off the SQL Server 2000 Developer Edition CD.

After installation is complete, there is a service under the Control Panel -> Services window
called MSSQL$GregInstance. I then start that service.

But now when I try to connect to the database using

osql -E -S GregInstance

I get told that the SQL Server does not exist or access denied. Even though the server is running. I have also tried

osql -E -S localhost

but no luck. Why can it not find the instance of SQL Server?

Note : SQL Server 2000 is not installed on the machine, only this MSDE instance.

Thanks
GregNot to worry, I forgot to add in the name of the pc with a \ before the instance name...

i.e

osql -E -S GREG\GregInstance

Wednesday, March 7, 2012

MSDE install on VS.NET 2003

I am trying to install MSDE according to:

http://www.siue.edu/~dbock/cmis460/msde.htm

But it says I need to go to control panel to install components, but it is not listed on the VS.NET 2003 install.

In VS.NET 2002 it worked fine as per instructions, but now i can't seem to get it to work in VS.nET 2003I removed the /qb+ option and it seems to work fine.|||I did the /c option. This too seems OK.