Link to home
Start Free TrialLog in
Avatar of Eric
EricFlag for Canada

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;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.
Avatar of lcohan
lcohan
Flag of Canada image

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."
Avatar of Eric

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 :)
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
Avatar of Eric

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 ?
ASKER CERTIFIED SOLUTION
Avatar of lcohan
lcohan
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Eric

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
Avatar of Eric

ASKER

Good Infrormation