Solved

Testing connection to sql

Posted on 2016-09-15
7
57 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
ID: 41800374
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
ID: 41800415
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
ID: 41800439
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
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 

Author Comment

by:toronto2456
ID: 41800479
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
ID: 41800500
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
ID: 41801560
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
ID: 41801562
Good Infrormation
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

914 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

12 Experts available now in Live!

Get 1:1 Help Now