How to get SQL Server Name Using Windows Authetication in C#

Question

I am trying to fetch the Server Name using C# for that I am trying blow mentioned code.

    SqlConnection con;
    SqlCommand cmd;
    SqlDataReader dr;

 con = new SqlConnection("Data Source=.;Database=Master;Integrated Security=SSPI");
                con.Open();
                cmd = new SqlCommand("select *  from sysservers  where srvproduct='SQL Server'", con);

                dr = cmd.ExecuteReader();

                while (dr.Read())
                {

                    ServerCollection.Add(dr[2].ToString());

                }

                dr.Close();

it's give me Exception like Login faild for user Dhaval.patel so can anyone please help how to connect using window's Authetication in C#.

on con.Open exception Login failed for user 'PLAYROOM\dhaval.patel'. InnerException null — Dhaval Patel
– Dhaval Patel, Commented Jul 17, 2014 at 6:50
Why you have defined Data source = . two times in connection string ? — Rajeev Kumar
– Rajeev Kumar, Commented Jul 17, 2014 at 6:51
Check if the server authentication mode is not set only to SQL Server Authentication. — Bayeni
– Bayeni, Commented Jul 17, 2014 at 7:07

Rajeev Kumar · Accepted Answer · 2014-07-17 06:52:55Z

1

Try to Put Integrated Security = true like this

con =  new SqlConnection("Data Source=.;Database=Master; Integrated Security=true");

answered Jul 17, 2014 at 6:52

Rajeev Kumar

4,9739 gold badges53 silver badges91 bronze badges

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

1 Comment

Rajeev Kumar Over a year ago

what is your sqlserver instance name ?

Neel · Accepted Answer · 2014-07-17 06:54:06Z

0

It should be like :-

 ("Server= localhost; Database=Master;Integrated Security=SSPI, Integrated Security=True");

If you have a named instance of SQL Server, you'll need to add that as well, e.g.,

"Server=localhost\sqlexpress"

answered Jul 17, 2014 at 6:54

Neel

11.7k3 gold badges46 silver badges63 bronze badges

3 Comments

Dhaval Patel Over a year ago

yes if I used the con = new SqlConnection("Data Source=.;Database=Master;data source=.; uid=" + UserName + "; pwd=" + Password + ";"); then it's working fine

Dhaval Patel Over a year ago

using SQL Authetication it's working fine but I want to open using Windows Authetication without any username and password

Neel Over a year ago

see this if kai help male to msdn.microsoft.com/en-us/library/ff647396.aspx @DhavalPatel

Collectives™ on Stack Overflow

How to get SQL Server Name Using Windows Authetication in C#

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related