Visual Studio 2005 "How do you connect/create a new sql database?"
Hello
I have just got the trial dvd for Visual Studio 2005 Professional
When trying to make a new sql server database, I get an error box:-
********************************************************************************************************
An error has occured while establishing a connection to the server. When connecting tp SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider: Named Pipes Provide, error: 40 - Could not open a connection to SQL Server)
********************************************************************************************************
My sql server is shown on my computer via server explorer, but it appears that sql is not configured correctly?
I just want it to work on the local machine, can you please help?
(I just want to connect to my SQL local server and create a new database via server explorer from Visual Studio)
Thanks
Gary.
Hello
I have just got the trial dvd for Visual Studio 2005 Professional
When trying to make a new sql server database, I get an error box:-
********************************************************************************************************
An error has occured while establishing a connection to the server. When connecting tp SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider: Named Pipes Provide, error: 40 - Could not open a connection to SQL Server)
********************************************************************************************************
My sql server is shown on my computer via server explorer, but it appears that sql is not configured correctly?
I just want it to work on the local machine, can you please help?
(I just want to connect to my SQL local server and create a new database via server explorer from Visual Studio)
Thanks
Gary.
Last edited: