Eric
asked on
Testing connection to sql
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;Ini tial Catalog=Database;Integrate d 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.
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;Ini
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.
ASKER
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 :)
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 :)
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
https://msdn.microsoft.com/en-us/library/ff647248.aspx
ASKER
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 ?
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 ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
ASKER
Good Infrormation
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."