PeterBaileyUk
asked on
Visual studio sees sql server but cannot connect
I am not sure how to setup the sqlserver so i can connect to a db in it. I am using windows authentication. the server name shows in the visual studio server name box but it fails when trying to connect.
guidance would be appreciated.
ee1.JPG
guidance would be appreciated.
ee1.JPG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok ive had a little success but inadvertantly now installed 2 sql servers, however i set the tcpip to the sql port and enabled it and now i can connect from visual studio.
the service is obviously running so how do i get rid of one of the servers? i have sqlexpress (this one connects now) and sqlexpress1
the pipes option named pipes is disabled.
i dont think i am too far away now
the service is obviously running so how do i get rid of one of the servers? i have sqlexpress (this one connects now) and sqlexpress1
the pipes option named pipes is disabled.
i dont think i am too far away now
You should be able to just select the unwanted version and delete it from the management console (if I remember correctly)
the service is obviously running so how do i get rid of one of the servers? i have sqlexpress (this one connects now) and sqlexpress1Define "get rid". You can always uninstall a SQL Server instance if that's you want.
To connect to a specific SQL Server instance you just need to provide the correct instance name in the connection screen.
ASKER
so how do i uninstall a SQL Server instance?
Just go to Programs and Features in Control Panel and choose Uninstall on the SQL Server component.
Can you check if the SQL Server Browser service is running?