I am new at SQL Servers. Don't know how to connect to server. Can anyone tell me how can I create new server for developing C# desktop application with database.
Asked
Active
Viewed 1,083 times
0
-
Server name: (localdb)\v11.0 – Ruby Nanthagopal Jan 11 '17 at 07:19
-
what version ur sql server is & is it express? – Circle Hsiao Jan 11 '17 at 07:31
-
@CircleHsiao its 2012, not express – ALi Raza Darr Jan 11 '17 at 07:33
-
Possible duplicate of [A network-related or instance-specific error occurred](http://dba.stackexchange.com/q/49365/5203) – GSerg Jan 11 '17 at 07:33
-
r u sure it is operating? u can check this by Sql Server Configuration Manager – Circle Hsiao Jan 11 '17 at 07:35
-
@CircleHsiao IT IS NOT SHOWING ANY ITEMS WHEN I CLICK THERE. – ALi Raza Darr Jan 11 '17 at 07:37
-
2http://stackoverflow.com/q/11629475/5396995 – Ruby Nanthagopal Jan 11 '17 at 07:43
3 Answers
0
For your local instance use:
.
and choose Windows Authentication so you don't have to enter SQL credentials.
hyankov
- 4,049
- 1
- 29
- 46
-
open SQL Server Manager and enable Named Pipes (should have been enabled by default) – hyankov Jan 11 '17 at 07:24
0
There is one easy way to Browse servers in your system
open your Connect to server Dialog box, in server name drop down you will find Browse for more option at last. 
Now, You will have two tabs, Local server and Network server.
In Local server, you can see your available MS SQL servers.
Bharat
- 5,869
- 4
- 38
- 58
0
This is the best place to start.
https://www.connectionstrings.com/
For your specific scenario, you want this.
https://www.connectionstrings.com/sql-server/
From there, you have several options.
Standard Security
Server=myServerAddress;Database=myDataBase;User Id=myUsername;
Password=myPassword;
OR
Trusted Connection
Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;
etc...
ASH
- 20,759
- 19
- 87
- 200