Solved

Testing connection to sql

Posted on 2016-09-15
7
49 Views
Last Modified: 2016-09-16
Hi,

I like to test the connection to SQL Server. My Web Site is running under AD account Domain\userA.

my connection string is connectionString="Data Source=server\instance;Initial Catalog=Database;Integrated Security=SSPI" providerName="System.Data.SqlClient"

I am not able to log in using UserA account as interactive login is disabled.  Does anyone know any way to test. I have tired UDL file and ODBC but they are taking current credentials logged in to Server.

I couldn't find a way to test the connection using domain\usera account under web site is running.

Thanks

F.
0
Comment
Question by:toronto2456
  • 4
  • 3
7 Comments
 
LVL 39

Expert Comment

by:lcohan
Comment Utility
Please give this a read/try: "Testing connectivity to Microsoft SQL Server without any tools installed"

http://www.diaryofaninja.com/blog/2013/11/18/testing-connectivity-to-microsoft-sql-server-without-any-tools-installed

"f you cannot connect to the server, verify the firewall settings, and then try to connect again."
0
 

Author Comment

by:toronto2456
Comment Utility
Hi Icohan,

Thanks. I actually am using this one but my question is how to make test against AD account. If you choose windows aut , then currently log in users will be used. The only way to force is to log in as that AD account but I can't becasue it is not interactive.

my app pool in runnning under AD account and my connection to SQL is not SQL log in but windows.

So that is I am trying to find a way :)
0
 
LVL 39

Expert Comment

by:lcohan
Comment Utility
Argh...sorry I missed that essential point - is this what you mean? Essentially  you need to "runAS" that AD User and please see details here about "How do I impersonate a specific (fixed) identity?"

https://msdn.microsoft.com/en-us/library/ff647248.aspx
0
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 

Author Comment

by:toronto2456
Comment Utility
No problem :)

I have tried to run ODBC and UDL using runas. But again it is taking the logged credential user. The only way I found is to run SQL Studio manegement run as. But I don't have any sql to install.

Interesting it seems so weird that There was no easy way for this , I sometimes don't understand programmers ?
0
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
Comment Utility
yak...right, no easy way out but....luckily SQL 2016 finally the SSMS is independent and can be used with any prior version of sql as per http://www.jasonstrate.com/2013/05/get-just-the-tools-ssms-download/ so you could download and install only that OR...you can get one of older versions of SQL Express and instat SSMS only. After that all you need is to start it like:

runas /netonly /user:domain\username "C:\path_to\ssms.exe"

then connect to the server in cause to see if it works.
0
 

Author Comment

by:toronto2456
Comment Utility
Thanks Icohan,

That is good advise but unfortunately there is an security measure here preventing authenticating service accounts , So I have no way to test it on my workstation,

But thanks for the information
0
 

Author Closing Comment

by:toronto2456
Comment Utility
Good Infrormation
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now