You will have to contact your database administrator and have them add you as a dbcreator role to the database server you wish to create the database on.

Hope that helps!

Hi yes, I tried to back up to a network drive, which works fine. I also tried to back up to other logical drives, and even created a shared folder...

You may need to add the Computer (i.e. DomainName\ComputerName$) to the Administrators group on the database server and ensure it has database access to your WSUS databases.

Additionally, ensure you...

You need to be a dbcreator on the server at least.

Did anyone have any extended knowledge on why sql server will not use tcp/ip when an alias or sql browser is used to connect to sql server on a non-standard...

ROFL - you're right! :w00t: didn't even look at that date! np

That red "squiggle" in SQL 7 means you are connected.

Ok,

I checked the client and the tcp protocol is first under the Client registry for MSSQLServer SN10.0.

So.. I changed the connection to the database to servername,portnumber in the registry for...

I just re-read your post Grumpy...

You disabled named pipes on the client? That may be the issue... where do I check for that? I checked the client's network protocol thru...

Yep, I was hoping for that too! I tried, believe me LOL

It's configured for tcp on the alias.

Did you have to make sure the apps were connecting with the...

Yep, that was a disaster because anything that connected to the server as the server name rather than a fully qualified <servername>,<portnumber> failed 🙁

Thank you both for your opinions 😎

I see your point, let's hope, pray, and pray again that I don't ever loose BOTH of my SAN disk arrays! LOL

I do some...

You may also want to check that the agent account for the named instance has administrative permission on the server if you are using a domain account to run the...

Hi there, it wasn't a link I don't believe the instructions are to:

Go to Add/Remove Programs and click Change. Choose Reporting services and continue. At some point you will have...

Thanks for the information, it helped tremendously! BOL did not provide good info on this process.

Good thing I was uninstalling from my Development server!