Yes, this is hard to say without some sort of code sample as the problem could occur at both places. It will be a coding issue most likely, though.

K. Brian...

The scripting is kind of nice. I noticed, at least for logins, it uses the old syntax (sp_addlogin for SQL Server login rather than CREATE LOGIN), probably so you can...

The only thing I'll say about alias is if you have to later drop the login, you may be tearing your hair out trying to figure out why you can't....

Then your best bet is a script or small console that does the work for you. The reason for the 4000 character limit within SQL Server is the limit for...

If the default was already listening on 1433, when you restarted the named instance, it wouldn't have been able to bind to port 1433. Hene the reason you can't connect...

The fixed database role db_ddladmin has the ability to create an object with dbo as owner, however, the owner must be specified with the object is created. For instance:

if you're talking about SQL Agent jobs, they correspond to logins (sysjobs has a sid column as a result). Since roles (at least ones we can define) are at the...

If your stored procedures are small enough (< 4000 characters), you could write a cursor to get the text of the stored procedure, change CREATE to ALTER, add WITH ENCRYPTION,...

Debugging cannot run under the local System account. The service must either be a local account created on the computer or a domain account.

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish...

Is the SQL Server service running under the local System account?

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

Did you stop and restart the SQL Server service?

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

If you know your SQL Server's TCP port, try connecting via: <server>,<port> through QA. Does that work?

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring...

Can you ping your SQL Server?

Can you ping other machines on the network through the VPN?

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

If you apply the cumulative patch for SQL Server, MS03-031, you'll get the .818 version. On SQL Server 2000, SP 3/3a is required. Here's the link:

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/Bulletin/MS03-031.asp

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start...

Congrats, Frank. And I don't think Steve, Andy, or Brian Knight are going to lock this thread just yet so you can receive the praise you...