ok im a CS student, installed visual studio .net, and im trying to connect to a ms sql database (Northwind), but I keep getting a error that "[DBNETLIB][ConnectionOpen(Connect()).] SQLServer does not exist or access denied" in visual studio whenever I try creating a new database connection. How do I know if SQL server is installed on my system? cuz in my systray I see SQL server service manager, is that the same thing as SQL server? or do I need to download the full version or something? also could it be that a certain port on my system is not open that SQL server requires to be open?
Thanks
Ron
The tray icon doesn't mean SQL is running, so use the tray icon to start SQL if it isn't. I do not know if SQL Express uses a tray icon, so i would assume you are using MSDE 2000. You might need to grant the user ASPNET access to the database.
SQL uses Port 1433. DTE services use ports 5000-5020, however I don't think you are using DTE.
No comments:
Post a Comment