November 6, 2003 at 12:55 pm
what im tasked
to do is I have a application ERS which is a environmental
app that is housed on another sever that acts as the
front end for the app...the sql server houses the database
of course LOL....but the developers of this ERS app stated that windows
authentication would not work...so I created the 2nd
instance with a sa authentication....
Now the app. will work if I install the front piece on the
sql server in IIS. but I cannot get to run from the front
end server that also has the app. installed in IIS on it.
I hope this info helps..
PS I also remember reading that you would get the 2nd
instance to work if you enabled another IP to the
server.., Not sure how I would do that and make the 2nd
instance bind to it?? Any Thought????
November 6, 2003 at 1:40 pm
The app needs to support server\instance connections. Not all do.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 6, 2003 at 1:43 pm
I have been told from the web developer that it does?? LOL
November 6, 2003 at 1:43 pm
I have been told from the web developer that it does?? LOL
November 6, 2003 at 1:43 pm
I have been told from the web developer that it does?? LOL
November 6, 2003 at 2:41 pm
What connection string are you using?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 7, 2003 at 5:18 am
Im new to SQL server world? so forgive me if this is a silly question but where would I find that out? in SQL or in the front end App.??
November 7, 2003 at 7:03 am
make sure with second instance of the port number, as well as port number coming in from web app.. make sure this new port you pick is open through any firewalls as well
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply