C# Windows application: connection string to connect to remote sql server 2008 using windows authentication

Question

I am developing a windows form application using c#. I want to connect to SQL Server 2008 which is in the server using windows authentication. Can anyone please provide me the connection string?

Note:

Domain is created in my server.
Remote access is enabled for the sql server
TCP/IP port is also enabled.

Please help me.I am struggling for this since 3 days.

Can you able to connect sql server using management studio? you can use the same server name as data source.if it is not connected then you should have check you installed sql server correctly or not — Raja Rajendraprasath
– Raja Rajendraprasath, Commented Apr 21, 2014 at 13:38

rory.ap · Accepted Answer · 2014-04-21 13:33:50Z

1

Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;

answered Apr 21, 2014 at 13:33

rory.ap

35.7k15 gold badges104 silver badges199 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

variable Over a year ago

In this scenario, how can I test whether the windows user has certain permissions like db_datareader and db_datawriter and if the user doesn't have these permissions then perform Application.Exit?

Raja Rajendraprasath · Accepted Answer · 2014-04-21 13:35:28Z

0

You can try this one if it is local.it will take the default instance.I think this will help you

Data Source=.;Initial Catalog=yourDBName;Integrated Security=True

answered Apr 21, 2014 at 13:35

Raja Rajendraprasath

2221 gold badge3 silver badges12 bronze badges

Comments

Mithun Ashok · Accepted Answer · 2014-04-21 13:38:25Z

0

I am not clear on the issue you are facing, are u running the Application on your domain cred, and you're able to access the DB? . What is your current DB connection string template? (3 days, seems like a long time for this issue, i must be missing something)

answered Apr 21, 2014 at 13:38

Mithun Ashok

3661 silver badge4 bronze badges

Comments

UvarajGopu · Accepted Answer · 2014-04-21 13:56:14Z

Follow the below steps in your visual studio,

Go To Tools menu and click on "Connect to Database".
If it is a first time a small window will open with below options
- Microsoft Access Database File
- Microsoft ODBC Data Source
- Microsoft SQL Server
- Microsoft SQL Server Comapct 3.5
- Microsoft SQL Server Database File
- Oracle Database
In your case, click on "Microsoft SQL Server" and click Continue.
Then a new window will prompt which takes input like -Server Name -choose your server name (First time it will take some time to load list of server name). You can get your server name by opeing SQL Server.
- Log on to the server
option 1 - Use Windows Authentication (As this is the first time you are using, I will suggest to use this option) option 2 - use SQL Server Authentication (If your choosing this, provide your SQL Server Username and password)
Connect to Database -Select or Enter the Database name (From the Dropdown select your database to which you want to connect)
After filling above details, Click on "Advanced" button and it will take you to another pop-up window
- In that window, just above "Ok" button there will be a non-editable column with name DataSource. Simply copy the text under it. This is you Connection string.

Collectives™ on Stack Overflow

C# Windows application: connection string to connect to remote sql server 2008 using windows authentication

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related