Hi -
I have a recurring problem with my sql server, the connection keeps on failing. I get the following error message:
______________________________________________
Connection failed:
SQLState: '080001'
SQL Server Error: 17
[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied.
______________________________________________

I cant quite understand this since my sql server is running (shown when i open my SQL Server Service Manager)

Does anyone have any suggestions at all??

thanks - rizp

The error means that you are using either a wrong server name or the user with which you are trying to connect is not permitted to.

What way are you trying to connect? Is that sql server running on a remote system, meaning - are you trying to connect to a sql server remotely? Can you explain more on that?

_________________________
- Vijay G
Strive for Perfection

Hi,

I have a local server on my laptop and sql server is also on the same machine - so no remote connection. when asked for a server name, i simply put in 'local' or alternatively i can use the name of the sql server. In Visual Studio.Net, in server explorer, it shows my sql server to be running - so i cant understand why the connection cant be opened......any ideas??

rizp

Did you try giving localhost instead of local?

_________________________
- Vijay G
Strive for Perfection

yes i have tried this but this doesnt seem to work either - in fact, the connection to the database is definately open since in the top menu bar of visStudio.net under tools, i can connect to a database - and this connects successfully.

I am using Windows XP professional edition....just a thought, when sql server gives the option of using windows NT integrated security - does this mean i can use this with the operating system that i am using too?

Was about to ask that, are you using windows login/password to connect to sql or SQL username/password to connect?

_________________________
- Vijay G
Strive for Perfection

using windows login, not sql server login

oh yeh...also note that when in server explorer, i can open up the table node and view a table that i had previously created with enterprise manager.

What is the Authentication used under Security tab of SQL server properties in Enterprise Manager?

_________________________
- Vijay G
Strive for Perfection

it is set to - windows only, audit level: none, start and run sql account in the following: System account.

by the way i am using sql server developer edition.