CODEWITHSUNDEEP
sql-servervisual-studio-2008
Supereme
Supereme

Reputation: 2409

Error while connecting to SQL Server from Visual Studio 2008

This error occurs when I was trying to connect to SQL Server 2005 which is there with VS 2008.

AN ERROR HAS OCCURRED WHILE ESTABLISHING CONNECTION TO THE SQL SERVER 2005. THIS FAILURE MAY BE CAUSED BY THE FACT THAT UNDER THE DEFAULT SETTINGS SQL SERVER DOES NOT ALLOW REMOTE CONNECTIONS.(PROVIDER:SQL NETWORK INTERFACE, ERROR:26. ERROR LOCATING SERVER/INSTANCE SPECIFIED.)

I am doing everything on local machine still it shows error for network. I tried to enable SQL Server browser but its not starting anyway.

How can this be solved?

Upvotes: 0

Views: 318

Answers (1)

Vishal Patel
Vishal Patel

Reputation: 281

You have to check for the rights of the folder in which your .net and inbuilt sql server is reside. You have to full rights of that folder.

Upvotes: 1

Related Questions