Cannot Use The Special Principal 'sa'. (Microsoft SQL Server, Error: 15405)
Dec 31, 2007
Hello All, I'm hoping someone else has run into this, because I can't find any posts about it that are helpfull.
I just updated our Dev SQL 2005 db to be able to use new 2005 key words with the script:
EXEC sp_dbcmptlevel 'myDbName' , 90
This is all well and good until I notice my sa account no longer has a user mapping to my database. In managment studio when I go to Security - Logins - and sa properties If I try to add user sa to my Db I get the following errors:
>>>------------------------------------------------------------------------------------------------------------->>>
Create failed for User 'sa'. (Microsoft.SqlServer.Smo)
Cannot use the special principal 'sa'. (Microsoft SQL Server, Error: 15405)
<<<-------------------------------------------------------------------------------------------------------------<<<
I'm access the SQL Server through a client on my local machine, the Server is set to mixed authentication, actual check box is labeled Sql Server and WIndows Authentication Mode. Hopefully I'm just doing something dumb, which is highly likely since I'm a developer and not a DBA.
Thanks in advance
View 2 Replies
ADVERTISEMENT
Nov 1, 2007
Hello,
The problem which i am facing in SQL Server 2005 is that, I have 2 database and the owner of both the databases is sa but when I go to database > security > users here I cannot find 'sa' as user. when I am going to add that user I get following error :
cannot use special principal 'sa'
also when I connect sa on other computer I will not connect
I have already checked following thing :
The Authontication mode of SQL is mixed mode
database owner is also sa
sa is also enable
Please can any one help me I am in big trouble
Thanks and Regards
Asif Fattah
ERP Consultant
View 4 Replies
View Related
Aug 29, 2006
Hello,
I am starting to use SQL Server 2005. I am having trouble connecting remotely. I tried to enable the 'sa' user and got this error:
Cannot use the special principal 'sa'
Is the 'sa' user no longer valid for remote connections?
Thank you
View 11 Replies
View Related
Dec 10, 2003
Hi Everybody,
On localhost this application works fine but when I put on remote server. I am getting following errors. For both localhost and server, I am using same remote sql 2000. I will appreciate any help.
Thanks,
Arif
Server Error in '/' Application.
--------------------------------------------------------------------------------
ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.]
Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode) +27
Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method) +838
Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery() +80
Calgary.venues.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootCalgarySitevenuesvenues.aspx.vb:32
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
View 5 Replies
View Related
Oct 18, 2007
Hi,
I am trying to create a linked server between 2 SQL Server 2005 boxes.
When I create the linked server I specify a login for the connection.
The strange part is that I get the following error when it goes to test the connection:
The test connection to the linked server failed
Login failed for user 'Domainuser'. (Microsoft SQL Server, Error: 18456)
I can use the SQL mangement studio to conenct to the database using this same login.
The login has all the server roles assigned to it also.
Can anyone shed some light as to what may be the problem?
Thanks,
View 5 Replies
View Related
Sep 26, 2007
We have mirroring setup for 5 dbs, 4 of which are synchronized and 1 which is in "synchronizing" state on the principal and "restoring" state on the mirror. Mirroring for all dbs has been working fine for the past several months and we have a witness that has allowed automatic failover in the past without problems.
This database has several bulk inserts performed throughout the day and am sure there is some latency due to the size of these transactions.
Not sure as to why this is happening all of a sudden, but the db in question has been in this state for the past 12 hrs. I checked the mirroring status on the principal and it states that it is "synchronizing: data is being transferred from principal to mirror", but the mirror server states that db is in "restoring" state. Can anyone suggest as to how I can get the database on the mirroring server to get back to "mirror, synchronizing/restoring..." state? Or suggest on how I can troubleshoot this?
Thanks in advance.
View 3 Replies
View Related
Aug 25, 2014
I am not able to launch the Kerberos Configuration Manager due to the above error.
View 4 Replies
View Related
Mar 2, 2007
1. Replication Transactional between two servers
-- SQL Server 2005 as Distributors and Subscribers
---SQL Server 2000 as Publishers
2. Linked Servers errors:
" Server (Publication Server) is not configured for DATA ACCESS. (Microsoft SQL Server, Error: 7411)"
Did anyone familiar with this problem?
Thankssss
TJ_1
View 4 Replies
View Related
Mar 1, 2007
Hi,
I am trying to connect to my SQL Server 2005 but it gave me following error message.
TITLE: Connect to Server
------------------------------
------------------------------
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)
So, Please help me to solve this problem.
tnks.
View 20 Replies
View Related
Jul 7, 2014
I have deleted a windows login user under security in SQL 2012 Management Studio. The users have also been removed from the associated databases. When I try to add back the login, I receive the message 'The server principal 'xxxx' already exists'. What do I need to do so that I can re-add the login ?
View 1 Replies
View Related
Aug 11, 2006
hymavathi gunta writes "hi all
i am working on sql server 2005
When i am trying to attach sample database called advanture dw in my server i am getting following error. Plz help me to fix this error.
the error as as follows :
Attach database failed for Server 'myserver'. (Microsoft.SqlServer.Smo)
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Could not find row in sysindexes for database ID 10, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Could not open new database 'ReportServer'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)"
View 9 Replies
View Related
Jan 21, 2008
I am attempting to create a new Database using Management Studio Express. However, it will not allow me. I get the error message:
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Cannot show requested dialog.
------------------------------
ADDITIONAL INFORMATION:
Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)
------------------------------
Failed to connect to server MCKINNEY-PCSQLEXPRESS. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
How cani correct this?
View 4 Replies
View Related
Oct 17, 2007
Hi,
I have installed Windows Server 2008 Enterprise Evaluation & Sql Server 2008 June CTP.
When I am trying to connect to Database Engine through Sql Server Management Studio then it Throws following Error
Cannot connect to MDT1000ADITYA
Additional Information
A Connection was Successfully established with the server, But then an error occurred during the login process. (provider : Shared Memory Provider, error: 0 €“No process is on the other end of pipe) (Microsoft Sql Server, Error : 233) €œ
where "MDT1000" is my machine name and "ADITYA" is Sqlserver name.
if some have any idea please suggest me what is wrong.
Thanks,
Aditya Bajpai
View 5 Replies
View Related
Sep 30, 2007
I am getting this error when connecting to sql. I cant get into my databases now- its pretty ugly.
"A connection was succesfulyl established with the server, but then an error occured during the login process.
(provider: Shared Memeory Provoder, error: 0 - No Process is on the other end of the pipe.)Microsoft SQL server error:233
Anyone who knows what is going on soem help would be much appreciated.
Mat
View 36 Replies
View Related
Aug 7, 2006
Hi,
Here is my testing environment:
Database server: SQL Server 2005 Developer Edition with SP1
Application: An application developed by Visual Studio 2005 using C# (.Net framework 2.0) and ADO .Net 2.0.
Principal server: computerA
Mirror server: computerB
Witness server: computerC
Mirroring mode: High availability with auto failover
Connection String:
Data Source=computerA;Failover Partner=computerB;Initial Catalog=test_mirroring;Persist Security Info=True;User ID=sa;
Code used for failover:
while (true)
{
thisDataSet = new DataSet();
try
{
thisConnection = new SqlConnection(connectionString);
thisAdapter = new SqlDataAdapter(SQL, thisConnection);
thisAdapter.Fill(thisDataSet, name);
break;
}
catch (SqlException e)
{
thisConnection = null;
thisAdapter = null;
thisDataSet = null;
}
}
Test Case:
(Part A) At the beginning of the test, computerA was in principal role. I started my testing application and connected to computerA without any problem. Then I disconnected the connection of computerA to the network by unplugging the network cable of computerA. The failover of database from computerA to computerB was carried out without problem. computerB was in principal role at that time. The application was pending for about 45 seconds and running again without problem. Then I re-connected computerA to network and it became the mirror server. computerB was still in principal role. Up to this point, all works fine, but the problem was coming next. (Part B) I disconnected computerB from network, database failover occurred, computerA became principal again. But my application cannot switch the database connection to computerA and then kept pending. Then, I re-connected computerB to network. It was surprised that the application switched the database connection to computerA successfully at that point.
My questions:
1. I think Part B is abnormal, isn€™t it? The application should be able to failover from computerB to computerA, because it works fine when failover from computerA to computerB.
2. Is there anything wrong in my code leads to the abnormal behavior of the application in Part B.
3. How can I achieve Part B? Any suggestion or idea?
Thanks for your attention.
View 6 Replies
View Related
Jul 23, 2005
Dear all,On Win2000 server with SP3, I am trying to access a SQL Server 7.0database, "TestDB", from VB6 via a SQL Server ODBC system DSN using ADO2.7. In SQL Server Enterprise Manager, there is a login named "Tester".In its property window, NO "Server Roles" was assigned but its"Database Access" was set to "TestDB". This login was also made as theuser of "TestDB" with "public", "db_datareader" and "db_datawriter"selected as its "Database role membership". All the tables I am tryingto access in "TestDB" were created under "Tester".My code is like:Set conn = New ADODB.Connectionconn.Open "DSN=TestDSN;UID=Tester;PWD=test"Set cmd = New ADODB.Commandcmd.ActiveConnection = conncmd.CommandText = SQLset rs = cmd.Execute()If I set the SQL to something like "SELECT * FROM tbl_test", I alwaysget an error of "-2147217865" saying "[Microsoft][ODBC SQL ServerDriver][SQL Server] Invalid object name tbl_test". If I set the SQL to"SELECT * FROM Tester.tbl_test", everything runs properly. Could anyoneplease kindly advise why the first SQL is not working? Or in otherwords, why must I prefix the table name with its owner while the DBconnection is already made under that owner name? Thanks in advance.Tracy
View 10 Replies
View Related
Nov 22, 2007
Hai,
I'm using SQL Server 2005 Standard Edition in my windows XP SP2 machine. I have only 1 server to which my 4 client machines are connected. Whenever I'm connecting to my SSMS using my domain account I get an error message indicating ' Login failed for user 'domain nameaccount name'.(Microsoft SQL Server, Error: 18456).I have tried with Microsoft's KB Article ID: 889646 and all other kind of stuffs. It's not helping me to sort out this problem. Could anyone help me outta here.
Narayanamoorthy
View 12 Replies
View Related
May 25, 2007
When I try to connect to MS SQL Server 2005 standard edition it appear the error message as [Either no algorithm has been specified or the bitlength and the algorithm specified for the key are not available in this installation of windows (Microsoft SQL Server, Error: 15314)].
Please anyone explain me how this error message mean. How to solve this matter to avoid this happen anymore.
Thank you
Simba
View 6 Replies
View Related
Nov 22, 2007
Hai,
I'm using SQL Server 2005 Standard Edition in my windows XP SP2 machine. I have only 1 server to which my 4 client machines are connected. Whenever I'm connecting to my SSMS using my domain account I get an error message indicating ' Login failed for user 'domain name account name '. (Microsoft SQL Server, Error: 18456). I have tried with Microsoft's KB Article ID: 889646 and all other kind of stuffs. It's not helping me to sort out this problem. Could anyone help me outta here.
View 6 Replies
View Related
Feb 27, 2008
Say i create a mirroring for a database without witness server, if the principal server is offline, can i make the mirroring database online?
thanks in advance.
View 7 Replies
View Related
Jun 20, 2007
Dear All,
I am trying to connect to a remote sql server 2005. So I have install the Microsoft SQL Server Management Studio Express. When I try to connect I get the error below.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53). Can some one please help. I have even port no 1533 on my pc. Thanks.
View 5 Replies
View Related
May 5, 2008
Hi,
I'm from Argentina, I'm running SQL Server 2005 Express. I can connect to SQL Server via Management Studio and see all my db but I don't have acces to them !!
The system gives me the following error when trying to expand all folders:
Database 4 cannot be autostarted during server shutdown or startup. (Microsoft SQL Server, Error: 904)
Any ideas??
Thanks from Argentina
View 3 Replies
View Related
Mar 2, 2004
Hi friends,
Can anyone help me in connecting sql server and asp.
Wheneever try to do the connection, I am getting following error. All the connection string which i am using are correct.
can you help me.
Following are the error line
----------------------------------------------------------------
Microsoft OLE DB Provider for SQL Server error '80004005'
Invalid connection string attribute
/MAsteringASP/global.asa, line 17
Microsoft OLE DB Provider for SQL Server error '80004005'
Invalid connection string attribute
/MAsteringASP/test2.asp, line 21
------------------------------------------------------
Please ckeck my code which I am using for connection
Thank you
Graceson MAthew
----------------------------------------------------------------
<%@ Language =VBScript %>
<% option explicit %>
<Html>
<head>
<title> Database Connection </title>
</head>
<body>
<%
<!-- #INCLUDE FILE="adovbs.inc" -->
dim conn
dim sql
dim r
dim aConnectionString
Set conn=Server.CreateObject("ADODB.Connection")
conn.Mode=adModeReadWrite
conn.Open="Provider=SQLOLEDB;UID=Administrator;Password=passw d;Initial Catalog=nrth;Datasource=server ip;Port Number= 80"
Response.Write (" Database Connectivity")
%>
</body>
</html>
View 10 Replies
View Related
Mar 8, 2004
Dear all,
Still i am having problem with connecting sql server with ASP (Intranet).
Following is the code which i am using for the connection now,
Set conn=Server.CreateObject("ADODB.Connection")
conn.open "DSN=aspfirst;Uid=;PWD=;"
The error mesage , generated by this code is attached with this mail. Please check the attachment and hel me in the same
Graceson
View 2 Replies
View Related
May 2, 2008
Hi everyone,
I am getting the below error when I try to access the table in 2005 database through 3rd party application from the application server.
“[Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt�
This database was restored from sqlserver 2000, so the ODBC connection in the application server first was pointing to 2000 database and now its dropped and recreated to point to the 2005 database.
I dont get this error message when I do the same action from my pc.
I google'd on this error message, and I am not sure if the driver has to be upgraded or if there is anything else that I am missing here.
Thanks much.
View 1 Replies
View Related
Nov 22, 2006
when i tried to login at SQL server 2005 by my local account i found an error (i login by the administrator account and use windows authentication) ... can any one help me plz??
View 2 Replies
View Related
Oct 16, 2006
I get Microsoft OLE DB Provider for SQL Server error '80040e37'
Invalid object name '#t_testTemp484883646'.
when I run the following ASP code:
------------------------------------------------------------Code is below---------------------------------------------------------
<!---#Include File="../includes/adovbs.inc" -->
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<TITLE></TITLE>
</HEAD>
<BODY>
<%
'----- Setup database connection
Set DataCmd = Server.CreateObject("ADODB.Connection")
Set rsData = Server.CreateObject("ADODB.RecordSet")
Dim varTempTableName
DataCmd.Open Application("DB")
'----- Use a Temp Table so that it gets destroyed automatically in case the page times out
'----- Use a Global Temp Table so that it is available across scopes when I open the record set below
'----- Append a semi unique number to the end because its global it could conflict with another browser running the same report
'varTempTableName = "##t_TestTemp" & Minute(Now()) & Second(Now())
varTempTableName = "#t_TestTemp" & Session.SessionID
strSQL = "Create Table " & varTempTableName & "(TestColumn2 int)"
DataCmd.Execute strSQL
strSQL = "select * from t_Test"
rsData.Open strSQL, DataCmd, adOpenForwardOnly,adLockReadOnly
Do While Not rsData.EOF
varTestColumn2 = rsData("TestColumn2")
'Error occurs when I place the following insert statement. Code works with the global variable
strSQL = "Insert into " & varTempTableName & " (TestColumn2) values (" & varTestColumn2 & ")"
DataCmd.Execute strSQL
rsData.MoveNext
Loop
rsData.Close
strSQL = "Drop Table " & varTempTableName
DataCmd.Execute strSQL
Set rsData = Nothing
Set DataCmd = Nothing
%>
</BODY>
</HTML>
View 1 Replies
View Related
Jan 7, 2008
"SQL Server is unable to run. Either the owning node or all nodes that currently part of the virtual server are not available. Review any SCC failures and validate that all nodes are online."
Can someone tell me what's the cause of this error?
How can this be corrected?
I am very grateful for all feedback.
View 1 Replies
View Related
May 5, 2008
Hello all,
I want to create a table in MS-Access. So I have written the following query.
Code Snippet
select * from Openquery(KKACC, 'select * Into Temp from Table select 1 as col1')
But I am getting the following error.
Code Snippet
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "KKACC" returned message "Syntax error in FROM clause.".
Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing the query "select * Into Temp from Table select 1 as col1" for execution against OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "KKACC".
How can I resolve this error. Does any one have any work arround for this..?
Thanks
-- Krishna
View 3 Replies
View Related
Jun 19, 2007
I can't seem to connect to our local instance of Microsoft SQL Server. I obtained the followinf infrotmation from the error log and I can't find anything in regards to Severity 14 and state 1. If anyone has any information in regards to this it would be much appreciated. Thanks in advance!
===================================
Cannot connect to 10.1.0.191.
===================================
Login failed for user 'kbober'. (.Net SqlClient Data Provider)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
------------------------------
Server Name: 10.1.0.191
Error Number: 18456
Severity: 14
State: 1
------------------------------
Program Location:
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
View 29 Replies
View Related
Mar 5, 2008
I was in the process of installing Microsof Project 2003 when we suddenly decided to move up to Microsoft Project 2007. We removed SharePoint 3.0 and SQL Server 2K so all that is installed on the box is Windows Server 2003 with all Service Packs. During the install of SQL Server 2005, here is the error message we get.
Microsoft SQL Server 2005 Setup
SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Cannot alter the login €˜sa€™, because it does not exist or you do not have permission.. Refer to the server error logs and Setup logs for detailed error information.
Any help is appreciated.
Thanks,
Ron
View 1 Replies
View Related
Apr 20, 2007
Hi,
I am working on sql server 2005 .
when I am trying to connect to server:
following error is occuring:
TITLE: Connect to Server
------------------------------
Cannot connect to servername
------------------------------
ADDITIONAL INFORMATION:
Cannot generate SSPI context. (Microsoft SQL Server, Error: 0)
Could any one help What might be the problem ? for this ?
Thanks,
Ramki
View 1 Replies
View Related
May 14, 2008
Hi all
This Job ran yester day fine,to day It got failed with this error
any suggestion to troubleshoot problem is appreciated.
DTSRun OnError: DTSStep_DTSTransferObjectsTask_1, Error = -2147203052 (80044814)
Error string: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Error source: Microsoft SQL-DMO (ODBC SQLState: 28000)
Help file: SQLDMO80.hlp
Help context: 1131
Error Detail Records:
Error: 0 (0); Provider Error: 0 (0)
Error string: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Error source: Microsoft SQL-DMO (ODBC SQLState: 28000)
Help file: SQLDMO80.hlp
Help context: 1131
DTSRun OnFinish: DTSStep_DTSTransferObjectsTask_1
DTSRun: Package execution complete.
View 3 Replies
View Related
