Invalid username or password

• mrroofer

  SSC Veteran

  Points: 265

  More actions

  November 14, 2007 at 4:00 am

  #751024

  Thank you for the Reply, Here's What I did.

  USE [master]

  GO

  --CREATE LOGIN [markr] WITH PASSWORD=N'roof1920', DEFAULT_DATABASE=[Roofing 92]

  GO

  USE [Roofing 92]

  GO

  drop user [markr]

  go

  CREATE USER [markr] FOR LOGIN [markr]

  GO

  ALTER USER [markr] WITH DEFAULT_SCHEMA=[dbo]

  GO

  EXEC sp_addrolemember N'db_datareader', N'markr'

  GO

  EXEC sp_addrolemember N'db_datawriter', N'markr'

  GO

  EXEC sp_addrolemember N'db_owner', N'markr'

  GO

  Every Thing Went Well.

  Started The Program, Asking For My Username markr with Password roof1920

  INVALID USERNAME OR PASSWORD.

  I Noticed When I Type My Username it Always is In Capitol Letters, Do You Think This Has Something To do With it.

  Thanks For All The Help

• mrroofer

  SSC Veteran

  Points: 265

  More actions

  November 14, 2007 at 4:09 am

  #751028

  Look at This, I went into Roofing 92 Database Click on View Server Permissions and this came up.

  TITLE: Microsoft SQL Server Management Studio Express

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

  Cannot show requested dialog.

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

  ADDITIONAL INFORMATION:

  Could not load file or assembly 'file:///C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlManagerUi.dll' or one of its dependencies. The system cannot find the file specified. (mscorlib)

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

  BUTTONS:

  OK

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

  What the this mean.

  Thanks again

• Johan Bijnens

  SSC Guru

  Points: 135556

  More actions

  November 14, 2007 at 4:10 am

  #751029

  by default userid's are not case sensitive, passwords are !

  Are you sure you're trying to connect to the correct server (your own SS2005Express)

  If you can provide a servername, try .\SQLExpress

  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

• mrroofer

  SSC Veteran

  Points: 265

  More actions

  November 14, 2007 at 5:40 am

  #751047

  Thank You Again,

  I Start Studio Express

  Choose the BWIXPD06\SQL (Which is the one I Installed on This Box)

  Windows Authentication

  Click Connect

  Goto Databases

  Click on Roofing 92

  Click Security

  Users

  Then I Can See All Users

  I Goto The Program I Can See BWIXPD06\SQL (SERVER NAME)

  I Check a Box for USE INTEGRATED SECURITY

  Click Get Available Databases

  The Roofing 92 Shows Up Which I Clicked it

  Then it Says to PLEASE SUPPLY A USER ID AND PASSWORD TO LOG INTO THE DATABASE

  I Enter markr

  Password roof1920

  INVAILID USERNAME OR PASSWORD

  THIS IS CRAZY, I DON'T HAVE A CLUE

  PLEASE, PLEASE HELP

• K. Brian Kelley

  SSC Guru

  Points: 114704

  More actions

  November 14, 2007 at 10:50 pm

  #751378

  mrroofer (11/14/2007)

  ---

  I Check a Box for USE INTEGRATED SECURITY

  Don't check this box. This is for when your Windows user account is passed through to the database "auto-magically." You've gone through the hassle of creating what we call a SQL Server login. In this case you don't want integrated security because you have a username and password you want to specify.

  K. Brian Kelley
  @kbriankelley

• Johan Bijnens

  SSC Guru

  Points: 135556

  More actions

  November 15, 2007 at 12:01 am

  #751385

  Because you are apparently using integrated security,

  I'm beginning to thing you application also has its own usermanagement. i.e. users stored in some table in your db. That may be the userid you're looking for.

  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

• mrroofer

  SSC Veteran

  Points: 265

  More actions

  November 15, 2007 at 5:25 am

  #751452

  Thank you for the info, you are probiley right, I wish could send you the database and look at it, and see what I'm doing wrong. It's about 42.4 meg.

  Thanks again

• mrroofer

  SSC Veteran

  Points: 265

  More actions

  November 15, 2007 at 5:58 am

  #751465

  When I tried to loginto Stuido Express I checked the box for loginto SQL Server and here's the error

  TITLE: Connect to Server

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

  Cannot connect to BWIXPD06\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

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

  BUTTONS:

  OK

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

  Can anybody tell me what this means

  Thank You Again and Again