?
Solved

SQL Query error

Posted on 2010-01-08
4
Medium Priority
?
265 Views
Last Modified: 2012-05-08
I have the following script in a batch file.  I am trying to run a query.  The problem is that I get an error that says SQL Network Interfaces: The target principal name is incorrect.  Sqlcmd: Error: Microsoft SQL Native Client: Cannot generate SSPI context

sqlcmd -S . -i "C:\Terminated Transfer.sql"
0
Comment
Question by:al4629740
4 Comments
 
LVL 41

Accepted Solution

by:
ralmada earned 501 total points
ID: 26232767
0
 
LVL 9

Assisted Solution

by:selva_kongu
selva_kongu earned 501 total points
ID: 26253083
Can you restart the both client and server and reset the dns settings. and then execute the query.
0
 
LVL 7

Assisted Solution

by:aplusexpert
aplusexpert earned 498 total points
ID: 26281729
osql -S (local)\SQLEXPRESS -d master -E -i CreateMasterDatabase.sql
0
 

Author Closing Comment

by:al4629740
ID: 31674886
Could not find answer, but thanks for the extra insight
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
This article was inspired by a question here at Experts Exchange (http://www.experts-exchange.com/Software/Photos_Graphics/Images_and_Photos/Q_28629170.html). The requirements stated in that question are (1) reduce the file size of a large number of…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question