Help! SQL errors after Win 2003 Upgrade

Help! I am in a jam and need help suggestions and ideas ASAP!
After performing an in-service operating system upgrade from Win 2000 to Win
2003 both of our SQL Server applications are behaving very badly. The SQL
applications are either giving us errors or unable to run at all. Veritas
Backup Exec is unablel to b
rowse the SQL Database and after working with them for several hours they ar
e stumped.
Has anyone else heard of this issue? Would a reinstall of SQL SP3a fix thi
s mess? Or is the best fix going to be an all night server format and reins
tall of Windows 2003, SQL 2000, and all of the applications?
Thanks! in advance for anything you can give me.
NC Beach BumReapply SP3a.
Uninstall Veritas agent.
Reinstall Veritas agent.
What other application connectivity errors are you getting?
Check your alias settings in Client Network Utility. You may need remove
any alias settings that force named pipes connection to a local instance. I
have seen some problems with SQL Agent on those circumstances
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"NC Beach Bum" <anonymous@.discussions.microsoft.com> wrote in message
news:66808E92-5A64-45AB-91C0-25321EC56C6C@.microsoft.com...
> Help! I am in a jam and need help suggestions and ideas ASAP!
> After performing an in-service operating system upgrade from Win 2000 to
Win 2003 both of our SQL Server applications are behaving very badly. The
SQL applications are either giving us errors or unable to run at all.
Veritas Backup Exec is unablel to browse the SQL Database and after working
with them for several hours they are stumped.
> Has anyone else heard of this issue? Would a reinstall of SQL SP3a fix
this mess? Or is the best fix going to be an all night server format and
reinstall of Windows 2003, SQL 2000, and all of the applications?
> Thanks! in advance for anything you can give me.
> NC Beach Bum
>|||Jeff,
THANKS! for your quick reply.
What I see in the applications are unable to make connections.
The web application is getting this error "Method '~' of object '~' failed."
It looks like the SQL Connections have been trashed.
One Accounting product is getting an error about not being able to log onto
the database.
Another Accounting product on the same SQL Server is not allowing us to post
data to the database.
I can live with the Veritas issues but the Accounting folks are getting a bi
t nasty.
Have you heard of this before and how confident are you that SQL SP3a will p
ut us back to normal?
NC Beach Bum|||"NC Beach Bum" <anonymous@.discussions.microsoft.com> wrote in message
news:DF20331F-C553-48C8-8D31-9A5745A81F24@.microsoft.com...
> Jeff,
> THANKS! for your quick reply.
> What I see in the applications are unable to make connections.
Try to add this in your connection string:
"Network Library=DBMSSOCN"|||Geoff,
I am going to try and update MDAC and the SQL Service Pack
1) Run the MDAC 2.8 install
2) Run the SQL SP3a install
Does this make sense to you and is this the order you would suggest?
Thanks! NC Beach Bum|||That is the correct order. It shouldn't hurt.
You should start checking connectivity an dsee what does and doesn't
connect. Start with IP connectivity (Ping) and then work on SQL
connectivity with query analyzer. Try local and remote from Query Analyzer
and see what happens. Find out what connectivity works and what does not.
If you can connect locally, what does 'SELECT @.@.Version' return? Windows
2003 will disable the IP stack for SQL without SP3a to protect from the
Slammer worm.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"NC Beach Bum" <anonymous@.discussions.microsoft.com> wrote in message
news:59DBF52D-F7AE-4ACD-81A4-639C8E7E4D95@.microsoft.com...
> Geoff,
> I am going to try and update MDAC and the SQL Service Pack
> 1) Run the MDAC 2.8 install
> 2) Run the SQL SP3a install
> Does this make sense to you and is this the order you would suggest?
> Thanks! NC Beach Bum