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

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

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

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

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

Hello, does any body know what this is, and whty I cannot log into my database

Please help

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'BUILTIN\Users')

CREATE USER [BUILTIN\Users] FOR...

USE [master]

GO

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

GO

USE [Roofing 92]

GO

CREATE USER [markr] FOR LOGIN [mroney]

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

It work but...

Thanks for all the help, Here's what I did USE [master]GOCREATE LOGIN [mroney] WITH PASSWORD=N'roof1920', DEFAULT_DATABASE=[Roofing 92]GOUSE [Roofing 92]GOCREATE USER [mroney] FOR LOGIN [mroney]GOALTER USER [mroney] WITH DEFAULT_SCHEMA=[dbo]GOEXEC sp_addrolemember N'db_datareader',...

Thanks for the replay, but could you please give me an idea on how to do that

Thanks a million

Thanks for all your help, I know you have better things to do. I think I'm starting to get in to this.

Ok I see the users under the database, and...

Thanks for all the help it means alot. After running the command (sp_change_users_login @action='Report') it says at the bottom of the Studio Express (Command(s) completed successfully.) for what ever that...

Thank you so much for the reply, I'm sorry how can I find that. I do have Studio Express but I don;t know what I'm looking for.

Thank you again