All,
I am running SQL05 Dev with AdventureWorks on my desktop with local admin rights. I also have it configured to connect locally since it's a DEV version of SQL.
When I use either of the connection strings below I get the error message at the end of this post.
Thanks,
>Scott
Here are the strings:
Data source=(local); initial catalog=AdventureWorks or Data source=(SQLDEV05); initial catalog=AdventureWorks
Here is the error message:
TITLE: Microsoft Report Designer
A connection cannot be made to the database.
Set and test the connection string.
ADDITIONAL INFORMATION:
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) (Microsoft SQL Server, Error: 2)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476
Although it should work if you are connecting locally, you may want to try enabling TCP/IP and Named Pipes connections (which are off by default) just to see if that solves the problem. You can do this through SQL Server Surface Area Configuration tool. Let us know if that works, if not, it may be a different issue.
|||Hi:
According to the connection string you posted, please try the following changes and see if any of them works for you:
Origional: "Data source=(local); initial catalog=AdventureWorks"
Modified: "Data source=(local); initial catalog=AdventureWorks; Integrated Security=true"
or
Origional: "Data source=(SQLDEV05); initial catalog=AdventureWorks;"
Modified: "Data source=SQLDEV05; initial catalog=AdventureWorks; Integrated Security=true"
For more information about connection string, please use the following link for references.
http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring.aspx
Hope this helps. :-)
Thanks.
No comments:
Post a Comment