different password to the one that i set.

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

different password to the one that i set.

Author

Topic

Jay123
Yak Posting Veteran

54 Posts

Posted - 2010-01-21 : 10:49:59

i created a new login and set a 6 character password.

when i clicked on the login name and select properties it has 15 dots for the password instead of 6.

why has sql changed my 6 character password to a unkown 15 character password.

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2010-01-21 : 10:54:12

Its get Encrypted so 6 to 15 charcters

Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled

http://senthilnagore.blogspot.com/

Jay123
Yak Posting Veteran

54 Posts

Posted - 2010-01-21 : 12:11:48

But it doesnt let me use the origional 6 charcter password to login. how am i supposed to set sql server logins if it changes my passwords.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-01-21 : 12:29:07

it doesn't change it. it only masks it so you can't see it.

if it isn't letting you log in using it, then you mistyped something

Jay123
Yak Posting Veteran

54 Posts

Posted - 2010-01-21 : 12:58:29

Thats what i thought but i deleted and reset the password 3 times. (its a very easy and short password).

ANY MORE IDEAS

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-01-21 : 14:04:05

how are you logging in?
is server set to allow remote connections?
what is the exact error message you get?
are u sysadmin on the sql server?

Jay123
Yak Posting Veteran

54 Posts

Posted - 2010-01-21 : 15:37:12

i log into sql using windows authentication.

but i added a sql server login, with username and password.

yes i am sysadmin, it is on my laptop and im the only one who uses it.

what do you mean by remote connections.

it is a login form on my site. it fails at step 5, CON.Open().

Thanks

Jay123
Yak Posting Veteran

54 Posts

Posted - 2010-01-21 : 16:08:04

Update:

i didnt try before now but i just tried to connect directly to sql useing sqwl management studio and it didnt let me connect with the newly created sql login.

im guessing i have something set up wrong.

any ideas

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-01-21 : 16:10:54

In SSMS, if you right-click the server instance, then click properties, then go to the connections tab, make sure "Allow remote connections to this server" is checked.

What is the exact error message you get when it executes the CON.Open()?

Let's see your connection string (you can xxx out the password when you post it).

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-01-21 : 16:13:39

when you created the login, did you leave "enforce password policy" checked? on the status tab, is login enabled and permission to connect to database engine granted?

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2010-01-21 : 16:57:11

In sql server properties, just check authentication is Mixed mode selected. Create user with your credential, log off and log on with new user name/password, at login screen select sql server authentication.

Jay123
Yak Posting Veteran

54 Posts

Posted - 2010-01-23 : 16:43:36

Mixed mode is selected.
enforce password policy is checked
login enabled and permission to connect to database engine is granted
Allow remote connections to this server is checked

What is the exact error message you get when it executes the CON.Open:

[SqlException (0x80131904): Login failed for user 'Jay'.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4849015
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2394
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +35
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +144
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +342
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +221
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +189
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +185
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +31
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +433
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +499
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +65
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
System.Data.SqlClient.SqlConnection.Open() +122
_Default.btnLogin_Click(Object sender, EventArgs e) in C:\Users\Jay\Desktop\WD\justForMe\Default.aspx.vb:45
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

Let's see your connection string (you can xxx out the password when you post it:

<connectionStrings>

<add name="justMe" connectionString="server=JAY\SQLEXPRESS;database=jwwebdesign;uid=Jay;pwd=XXXXXX" providerName="System.Data.SqlClient"/>

</connectionStrings>

And when i try to log into ssms with the created login i get this error message:

TITLE: Connect to Server
------------------------------

Cannot connect to JAY\SQLEXPRESS.

------------------------------
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 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

--------------------------

Thanks for trying to help

Jay123
Yak Posting Veteran

54 Posts

Posted - 2010-01-24 : 15:29:47

Still need some help please......

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources