I have a REALLY easy question!

Question

Post reply

I have a REALLY easy question!

Ariadne

SSCrazy

Points: 2044
More actions
January 1, 2007 at 12:29 pm

#368698

Having worked with companies that don't use either workgroups or active directory, I'm really ignorant of what the .\ means before the login? I'm really in a bind as I'm working on this contract server that has its SQL service running under an account that is listed as .\sqladmin
I've had to change the password on the service account (It's a local account) and I'm trying to get SQL Agent's service to run under .\sqladmin but it keeps telling me the account doesn't exist. When I fall back on the tried and true machinename\sqladmin I get that account doesn't exist either. Now keep in mind that I think I'm on a virtual machine as the name that appears for SELECT @@ServerName is not the name that is showing up in machine name properties. I'm thinking the .\ has something to do with this? I've seen it used before in another company.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 1

Usually that is a Windows Domain account and not a sql account.

Hope this helps...

Ford Fairlane
Rock and Roll Detective

Johan Bijnens SSC Guru Points: 135368 More actions · Answer 2

. means local computer.

.\mylogin is windows-userid mylogin at the local computer. It is not a domainaccount.

Likewize with SSMS you can connect to . meaning you want to connect to the local default instance of sqlserver.

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

MVDBA (Mike Vessey) SSC-Insane Points: 21797 More actions · Answer 3

if @@servername returns different to serverproperty('machinename') then it's possible your server has been renamed??? - that MIGHT acount for the .\accountname not working correctly ????

you can rename your sql instance to the same as the machinename by doing

exec sp_dropserver @@servername

exec sp_addserver serverproperty('machinename'), local

best if you look these up in books on-line first though

MVDBA

Ariadne SSCrazy Points: 2044 More actions · Answer 4

Thank you alzadba for answering. It's exactly the knowledge I needed.

Johan Bijnens SSC Guru Points: 135368 More actions · Answer 5

I hope this was the first of a series of usefull answers for this year