Solved

Testing connection to sql

Posted on 2016-09-15
7
68 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 40

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 40

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
Is Your DevOps Pipeline Leaking?

Is your CI/CD pipeline a hodge-podge of randomly connected tools? You’ve likely got a tool to fix one problem & then a different tool to fix another, resulting in a cluster of tools with overlapping functionality. Learn how to optimize your pipeline with Gartner's recommendations

 

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 40

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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
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 shrink a transaction log file down to a reasonable size.

752 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