Data base connectivity

[Reethika]

My sql server is connected thro windows authentication, how to connect these DB in asp.net

[Sathiyaraj Ganesan]

Hi Reethi, Try this... Data Source=;Initial Catalog=;Integrated Security=True

Sathiya

[Reethika]

its not working, showing errors

[Sathiyaraj Ganesan]

what is the error?

Sathiya

[SathyaSiva]

Use like this Server=SERVER;Database=ABC;Uid=sa; PWD=12; Connect Timeout=360; pooling=true; Max Pool Size=200

Sathya

[Sathiyaraj Ganesan]

Data Source=(Server Name/IP/PC Name);Initial Catalog=(DB Name);Integrated Security=True

Sathiya

[Reethika]

stil i get the error like "login failed"

[Reethika]

am getting the error like "only elements are allowed"

[Sathiyaraj Ganesan]

Understand the question first dear... If it's "Windows Authentication". There'll be no Uid/pwd. Setting -"Integrated Secruity" to "True/SSPI" will solve the problem.

Sathiya

[Sathiyaraj Ganesan]

Now Start->SQLserver Mgmt Studio-> Login using Windows Authentication. Check whether you can able to connect.

Sathiya

[Arindam Tewary]

Someone shoud be invited to your place so that you can get it done ... otherwise seems connecting to DB is too hard for you .... LOL !! You should have known whats Sql Server authentication and Windows Authentication ..... if you dont read or gather any knowledge ... 1000 posts will be null and void !!!! :-D Try to read something at least ....

Thanks, Arindam D Tewary

[Sathiyaraj Ganesan]

Don't degrade others. If they are learning phase.

Sathiya

[Reethika]

i know the diff between both, I doesn't need any of ur advice.

[Reethika]

Thank u very much for ur words

[Sathiyaraj Ganesan]

Problem is solved or not.

Sathiya

[SathyaSiva]

Rathi don't get tension try surly u will solve the problem

Sathya

[Arindam Tewary]

It does't make any differece if you dont use your knowledge while working. and specilly if question reflects other thing !! Anyway ... happy coding and posting ..... you can again ignore this advice also .. :laugh:

Thanks, Arindam D Tewary

[Abhijit Jana]

Hi Reethika, before posting such questuions and spamming the sites try to search google or read some book. please have a look How To: Connect to SQL Server Using Windows Authentication in ASP.NET 2.0[^]

Best Regards ----------------- Abhijit Jana Check Out My Latest Article Java.NET : Integration of Java and .NET[^] "Success is Journey it's not a destination"

[Abhijit Jana]

SathyaSiva wrote:

Rathi don't get tension try surly u will solve the problem

This is not a Chat Forum.

Best Regards ----------------- Abhijit Jana Check Out My Latest Article Java.NET : Integration of Java and .NET[^] "Success is Journey it's not a destination"

[SathyaSiva]

u also use this like chat

Sathya