Moving SQL Server 2000 from an NT4 to Active Directory

Hi,
I'm afraid that I'm not very familiar with SQL Server so I was
wondering if anyone could point me in the right direction of what to
check?
We have just moved a SQL Server from NT4 to AD, all seems to go well
database started up ok and we were able to gain access to the data.
However we found a problem when running one of our internal web apps
which connects to SQL using a script file. The script file has changed
at all since we moved domains and we haven't changed the access rights
of the database user specified within the database. When we try to
login to the web app we get a page can't be displayed error, featuring
the following information
Error Type:
Mircosoft OLE DB provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver] Timeout expired
/sar/includes/connection.asp, line 13
Page:
POST 51 byres to /sar/login/login_do.asp
Post Data:
txtUsername=TEST&txtPassword=Password&Submit=Login
I was wondering if it has anything to do with WINS, we haven't yet
migrated over the WINS Server as there are a couple of things we have
to do before we can change the domain.
Any help or pointers will be greatly appreciated.
Many Thanks
Jamie
It could be a name resolution problem. You can force the use of DNS by using
a fully qualified domain name in your connection string.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Jamie" <jamie.m.garner@.gmail.com> wrote in message
news:1161105773.398539.112730@.k70g2000cwa.googlegr oups.com...
> Hi,
> I'm afraid that I'm not very familiar with SQL Server so I was
> wondering if anyone could point me in the right direction of what to
> check?
> We have just moved a SQL Server from NT4 to AD, all seems to go well
> database started up ok and we were able to gain access to the data.
> However we found a problem when running one of our internal web apps
> which connects to SQL using a script file. The script file has changed
> at all since we moved domains and we haven't changed the access rights
> of the database user specified within the database. When we try to
> login to the web app we get a page can't be displayed error, featuring
> the following information
> Error Type:
> Mircosoft OLE DB provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC SQL Server Driver] Timeout expired
> /sar/includes/connection.asp, line 13
> Page:
> POST 51 byres to /sar/login/login_do.asp
> Post Data:
> txtUsername=TEST&txtPassword=Password&Submit=Login
> I was wondering if it has anything to do with WINS, we haven't yet
> migrated over the WINS Server as there are a couple of things we have
> to do before we can change the domain.
> Any help or pointers will be greatly appreciated.
> Many Thanks
> Jamie
>
|||Thanks,
I'll give that a try
Jamie
Hilary Cotter wrote:[vbcol=seagreen]
> It could be a name resolution problem. You can force the use of DNS by using
> a fully qualified domain name in your connection string.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Jamie" <jamie.m.garner@.gmail.com> wrote in message
> news:1161105773.398539.112730@.k70g2000cwa.googlegr oups.com...