SQL Config

[MTSkull]

After reading the sticky and following the links I am still unable to get successful connection to my local db. I can see and modify the SQL data base in the server explorer in .net studio. I do not get errors when it processes the connection string in running code, but when it tries to open the database it says it can not connect and that a possible cause is a database default is not set to allow remoting, which is where I am stuck. I have tried everything I can think of, most of which is playing with user names, permissions and such to no avail. I can not find a setting to allow a remoting option to be set, nor can I find the setup.ini file that is referred to in most of the help pages.

 

Thanks

MT

 

 

Text of the error message

"An error has occurred while establishing a connection to the server. When connecting to 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 Provider, error: 40 - Could not open a connection to SQL Server)"

[MTSkull]

Fixed, sort of...

 

Well I still cannot get a connection via the SQLClient class. So I created a DSN and tried connecting via ODBC, not sure why this should work and not SQL but it does so I am pressing on and will come back to this later and solve it when I have more patience and time.

 

MT