Ignacio A. Salom Rangel (8/18/2008)

---

Hi Brian,

We start the SQL service with a domain account. This account does not have the "write service principalname" permission. That is why there is no...

I played flute, piccolo, trumpet, and french horn in high school and then it was my military duty at The Citadel (Regimental Band and Pipes). I've stayed somewhat active on...

For most of these you can add -nosplash to eliminate the splash screen. Loads a few seconds faster. For instance:

sqlwb -nosplash

If that's the case, it's probably a good idea to go ahead and engage Microsoft support and allow them to remote in. If it is affecting business processes, let 'em...

If SQL Server is in single-user mode, only one connection is going to be allowed, whoever is first. If something beats SQL Server Agent in, it can't read information out...

I understand that it's a cluster. However, what the cluster service basically does is start the appropriate SQL Server service on one node and keeps it stopped on all the...

That's the execution of said stored procedure. Do something like:

USE itiserver

GO

EXEC sp_helptext csp_AddDMUser

Judging by the name of the stored procedure, it is probably creating a login to the SQL Server...

Yes, it should. Meaning when you kick off the application and the error is generated, immediately check the SQL error logs. See what login shows up as failed.

When you check the service itself using the Services snap-in, does the Path to executable include a -m?

What are some of the requirements? The applications used to encrypt SQL Server and the ones to do full disk encryption or even partial encryption on workstations are not the...

In SSMS, if the server is listed in the Object Explorer:

- Right click on the server and choose Properties.

- Click Security in the left pane.

- Look at the second section...

I would assume so, but to be honest, I've not tried it. I've only had to deal with collations when a 3rd party vendor insists on the whole binary sort...

Lowell (8/15/2008)

---

when i changed the sql to see some more information, i can find the db they connect to, username, and some other info...but i don't see the spid...how can...

Maxer (8/15/2008)

---

I have the trace with the column filters on LoginName setup in profiler and had it export it out to script trace definition for MSSQL 05.

Though if the script...

Two other DMVs provide the info you're looking for:

- sys.dm_exec_sessions

- sys.dm_exec_connections