This happens for login of type windows authentication .

getting error due to login which are created at windows level or AD level .

plz check it using SQL security errorlog .ie...

sqlcmd failed using windows authentication ..-E

it basically happens due to if installation done from different login and now

you login into server with different login...

in this case what...

hi,

as seen in snapshot there is problem with sql server agent ..

plz check using 'sp_configure '

'Agent Xp ' option ... it is enable or not.

if you are deleting your publication...

hi how you got for answer this..

same error coming in one of my server.

i have made localhost servername entry in hostfile ..

then restarted server ..

it works ..

regards,

HEMANT..

hi,

plz check location of excel file from where your importing ..

check whether no one accessing file or might be file open..

regards

HEMANT

As mention ,log file extension idf .Database is accessible but in case of attach detach process it might create problem .

Regards,

HEMANT

what u can do first check port using telnet ,firewall.

if all ok then i think use hostname in connection string also make entry in host file .this will work.

i had face similar problem one of my server.

I got solution for this.

please find below link.

http://stackoverflow.com/questions/3389312/allow-ad-hoc-distribution-queries-for-all-users

hope this will work for you.

before doing change in registry first take...

there are several option available.

like logshipping ,mirroring ,replication .

database replication has to done when some table,sp are critical and you want to replicate then to staging database.

or you want entire...

hi ,i m executing DBCC checkdb on weekends for large database , bcoz its taking more time to execute .

Need suggestion whether to execute daily..

hi,

please check no of linked server .

also you should keep output of sp_configure before migrating to new server.

hi ,

i think this will you in some manner

http://www.sqlservercentral.com/Forums/Topic1142189-392-1.aspx

have check net response using ping -t

hi ,

please check below link..

http://blog.sqlauthority.com/2007/10/19/sql-server-types-of-dbcc-commands-when-used-as-database-console-commands/

in this commands,most frequetly used command are

DBCC INPUTBUFFER(Spid) to get query

DBCC shrinkfile(file_id ,size) to shrink file

hi,

please refer below link, it will help u.

http://www.howtogeek.com/118452/how-to-map-network-drives-from-the-command-prompt-in-windows/

hi ,

tempdb size increases due to several reason .

may be lot of records inserted or updated,

if large amount of data sorting is done.

Someone created index with option sort in tempdb...