ansaurus

Question

IIS to access SQL server on different machine

Answer 1

+3 A:

I would check to make sure that you instance of SqlExpress will accept outside connections:

http://blogs.msdn.com/b/sqlexpress/archive/2005/05/05/415084.aspx

Kevin 2010-10-12 19:04:14

i enabled the remote connection still the above error is showing... may be its not able to access that server

2010-10-12 19:49:50

The other thing I would check is that you need to make sure that your account accessing that sql server has rights on the new machine. I would guess you are a using an account local to the machine with IIS on it.

Kevin 2010-10-12 19:51:41

im looking into it.. thanks

2010-10-12 19:56:49

Hey how do i check the account accessing that sql server has rights on the new machine. yes my account will be on the machine where the IIS is. You are being really helpful.. hope this works... thanks

2010-10-12 19:59:10

I'll admit I just skimmed the article, but I think this will point you in the right direction: http://msdn.microsoft.com/en-us/library/bsz5788z.aspx

Kevin 2010-10-12 20:10:12

ok i made some fire wall changes but now i get this error:

2010-10-12 21:03:24

Login failed. The login is from an untrusted domain and cannot be used with Windows authentication

2010-10-12 21:03:56

oh...you're going cross domain. Truthfully, I would switch the connection string to use SQL Server authentication. It's going to be a lot easier than doing cross domain trusts with Active Directory.

Kevin 2010-10-12 21:08:11

true, even i dont want to use active directory... im figuring out a way to do so.

2010-10-12 21:24:37

if u have a link to share abt how to use SQL server authentication it could be of help.. but anyways iv given u the correct answer coz most of it worked and i think im close to solve it... thanks

2010-10-12 21:25:51

this should show the connection string etc: http://msdn.microsoft.com/en-us/library/ff648340.aspx

Kevin 2010-10-13 00:58:30

Answer 2

+4 A:

In Data Source, localhost is the name of the server and SQLEXPRESS is the named instance of SQL running on that server.

So either you do not have a named instance on the new server or the named instance is different.

OR like Kevin said, your instance is not accepting outside connections.

Tony Abrams 2010-10-12 19:07:53

ansaurus

tags:

views:

answers:

IIS to access SQL server on different machine

related questions