November 9, 2007 at 12:39 pm
Please help, I’m no SQL Administrator by any means. I use a program that runs off SQL, The program has a backup database witch I restored from SQL Server Management Studio Express every thing restored well so I think, BUT when I start the program I choose the database then it asking for a username and password, so I enter my Windows account login name witch has administrator rights it says INVAILED USERNAME OR PASSWORD. How can I fix the major Headache I’ve created.
Please any Idea
November 9, 2007 at 1:33 pm
apparently your application uses sql-authentication, not windows authentication.
use mamagement studio for ss2005 express to find out which user account is being used by the database.
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
November 12, 2007 at 7:42 am
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
November 12, 2007 at 1:10 pm
I don't have SSMSexpress in use, but I think if you use the object browser, there is a security menu item, if you open that it will show you all available users for sqlserver.
you can use
sp_change_users_login @action='Report'
to get an overview of missing users (at serverlevel).
Check Booksonline for more info. (post the results)
Using
sp_change_users_login @action='Auto_Fix',...
you can get it back to a working state.
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
November 12, 2007 at 2:12 pm
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 means, but when I run the other command (sp_change_users_login @action='Auto_Fix',...) This is the error message I get
(Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '.'.)
Sorry I feel real stupid, I've messing with this for months and getting no were. Can anyone recommend a book.
Thanks everyone for all the help.
November 13, 2007 at 12:10 am
if the 'report' option did not show a result row, that would mean that all sql-userid's are mapped to the sqlserver server level. That's OK.
Maybe in the originating server, there was a sql-userid stated as database owner, that may be a little caveot.
Te Auto-fix option, does not autofix by itself, you have to provide thet other parameters (,...) so it will work for you.
Now you'll have to take a look at the existing sql users in the database itself. in the object explorer, if you open the database, and browse to the security item, can you see sql-userid(s) ?
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
November 13, 2007 at 3:53 am
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 I added my self to it, but still can't logon. Here's the users I copied
USE [Roofing 92]
GO
/****** Object: User [dbo] Script Date: 11/13/2007 05:44:13 ******/
GO
CREATE USER [dbo] WITH DEFAULT_SCHEMA=[dbo]
GO
/****** Object: User Script Date: 11/13/2007 05:44:13 ******/
GO
CREATE USER WITH DEFAULT_SCHEMA=
GO
/****** Object: User [INFORMATION_SCHEMA] Script Date: 11/13/2007 05:44:13 ******/
GO
CREATE USER [INFORMATION_SCHEMA]
GO
/****** Object: User [mroney] Script Date: 11/13/2007 05:44:13 ******/
GO
CREATE USER [mroney] FOR LOGIN [BWIXPD06\mroney] WITH DEFAULT_SCHEMA=[dbo]
GO
/****** Object: User [sys] Script Date: 11/13/2007 05:44:13 ******/
GO
CREATE USER (sys)
Is there something I should see or do here, this is starting to get fun, what should do next
November 13, 2007 at 4:01 am
Apparently there is no explicit SQL-userid (except for the default ones) in the db, but your application expects a userid and a password.
I would in this case create a new sql-userid and grant it db_datareader and db_datawriter for this testcase.
If there are also storedprocedures, ... in the db, maybe even make it member of db_owner group,
Keep in mind this is just for this TESTING case !
Then use this sql userid for input in your application.
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
November 13, 2007 at 6:03 am
Thanks for the replay, but could you please give me an idea on how to do that
Thanks a million
November 13, 2007 at 6:45 am
Open a query window, copy/paste the script, modify it and run it.
USE [master]
GO
CREATE LOGIN [yourSQLUserId] WITH PASSWORD=N'T0pSecretP@ssword2', DEFAULT_DATABASE=[yourdatabasename]
GO
USE [yourdatabasename]
GO
CREATE USER [yourSQLUserId] FOR LOGIN [yourSQLUserId]
GO
ALTER USER [yourSQLUserId] WITH DEFAULT_SCHEMA=[dbo]
GO
EXEC sp_addrolemember N'db_datareader', N'yourSQLUserId'
GO
EXEC sp_addrolemember N'db_datawriter', N'yourSQLUserId'
GO
EXEC sp_addrolemember N'db_owner', N'yourSQLUserId'
GO
If this did complete with success, you should be able to use your application providing yourSQLUserId and its password.
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
November 13, 2007 at 7:38 am
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', N'yourSQLUserId'GOEXEC sp_addrolemember N'db_datawriter', N'yourSQLUserId'GOEXEC sp_addrolemember N'db_owner', N'yourSQLUserId'GO
Here's the error it gave Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'GOCREATE'.
Msg 319, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.
Msg 319, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.
Thanks a million again
November 13, 2007 at 8:22 am
It looks like you lost your LF/CR when you copied the script. GO and CREATE should be on separate lines... it looks like all of them were stripped.
K. Brian Kelley
@kbriankelley
November 13, 2007 at 8:39 am
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 still unable to log in data base
Thanks for all your help
November 13, 2007 at 1:22 pm
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 LOGIN [BUILTIN\Users]
GO
IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'BWIXPD06\SQLServer2005MSSQLUser$BWIXPD06$SQL')
CREATE USER [BWIXPD06\SQLServer2005MSSQLUser$BWIXPD06$SQL] FOR LOGIN [BWIXPD06\SQLServer2005MSSQLUser$BWIXPD06$SQL]
GO
IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'markr')
CREATE USER [markr] FOR LOGIN [mroney] WITH DEFAULT_SCHEMA=[dbo]
GO
IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'mroney')
CREATE USER [mroney] FOR LOGIN [BWIXPD06\mroney] WITH DEFAULT_SCHEMA=[dbo]
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_ID' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_ID] FROM [int] NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_INTEGER' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_INTEGER] FROM [int] NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_FLOAT' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_FLOAT] FROM [float] NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_BLOB' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_BLOB] FROM [image] NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_MEMO' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_MEMO] FROM [text] NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_TIMESTAMP' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_TIMESTAMP] FROM [datetime] NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_COMPANYNAME' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_COMPANYNAME] FROM [varchar](50) NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_NAME' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_NAME] FROM [varchar](30) NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_ADDRESS' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_ADDRESS] FROM [varchar](50) NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_CITY' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_CITY] FROM [varchar](30) NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_STATE' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_STATE] FROM [varchar](20) NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_ZIP' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_ZIP] FROM [varchar](10) NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_PHONE' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_PHONE] FROM [varchar](20) NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_CATEGORY' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_CATEGORY] FROM [varchar](20) NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_EMAIL' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_EMAIL] FROM [varchar](40) NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_URL' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_URL] FROM [varchar](60) NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_CODE' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_CODE] FROM [varchar](12) NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_FIELDTITLE' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_FIELDTITLE] FROM [varchar](12) NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_DESCRIPTION' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_DESCRIPTION] FROM [varchar](50) NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_TAXCLASSDESC' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_TAXCLASSDESC] FROM [varchar](20) NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_FIRETESTFORMULA' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_FIRETESTFORMULA] FROM [varchar](40) NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_MARKUPDESC' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_MARKUPDESC] FROM [varchar](12) NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_CQTY' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_CQTY] FROM [varchar](255) NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_ITEMDESCRIPTION' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_ITEMDESCRIPTION] FROM [varchar](255) NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_ACOUSTICROOMSIZEDESC' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_ACOUSTICROOMSIZEDESC] FROM [varchar](10) NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_EU' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_EU] FROM [varchar](6) NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_OU' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_OU] FROM [varchar](6) NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_PU' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_PU] FROM [varchar](6) NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_FORMULA' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_FORMULA] FROM [varchar](255) NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_MANUFACTURER' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_MANUFACTURER] FROM [varchar](50) NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_SCALE' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_SCALE] FROM [varchar](20) NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_TIMBERLINETAXCLASSSTRING' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_TIMBERLINETAXCLASSSTRING] FROM [varchar](10) NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_USERID' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_USERID] FROM [varchar](12) NULL
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_TIMBERLINEPRICE' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_TIMBERLINEPRICE] FROM [int] NULL
GO
EXEC sys.sp_bindefault @defname=N'[dbo].[TIMBERLINEPRICE_DEFAULT]', @objname=N'[dbo].[DOM_TIMBERLINEPRICE]' , @futureonly='futureonly'
GO
EXEC sys.sp_bindrule @rulename=N'[dbo].[TIMBERLINEPRICE_RULE]', @objname=N'[dbo].[DOM_TIMBERLINEPRICE]' , @futureonly='futureonly'
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_DETAILTYPE' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_DETAILTYPE] FROM [int] NULL
GO
EXEC sys.sp_bindefault @defname=N'[dbo].[DETAILTYPE_DEFAULT]', @objname=N'[dbo].[DOM_DETAILTYPE]' , @futureonly='futureonly'
GO
EXEC sys.sp_bindrule @rulename=N'[dbo].[DETAILTYPE_RULE]', @objname=N'[dbo].[DOM_DETAILTYPE]' , @futureonly='futureonly'
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_TIMBERLINEQUANTITY' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_TIMBERLINEQUANTITY] FROM [int] NULL
GO
EXEC sys.sp_bindefault @defname=N'[dbo].[TIMBERLINEQUANTITY_DEFAULT]', @objname=N'[dbo].[DOM_TIMBERLINEQUANTITY]' , @futureonly='futureonly'
GO
EXEC sys.sp_bindrule @rulename=N'[dbo].[TIMBERLINEQUANTITY_RULE]', @objname=N'[dbo].[DOM_TIMBERLINEQUANTITY]' , @futureonly='futureonly'
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_AMERICANCONTRACTORSORT' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_AMERICANCONTRACTORSORT] FROM [int] NULL
GO
EXEC sys.sp_bindefault @defname=N'[dbo].[AMERICANCONTRACTORSORT_DEFAULT]', @objname=N'[dbo].[DOM_AMERICANCONTRACTORSORT]' , @futureonly='futureonly'
GO
EXEC sys.sp_bindrule @rulename=N'[dbo].[AMERICANCONTRACTORSORT_RULE]', @objname=N'[dbo].[DOM_AMERICANCONTRACTORSORT]' , @futureonly='futureonly'
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_ONOFFAUTO' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_ONOFFAUTO] FROM [int] NULL
GO
EXEC sys.sp_bindefault @defname=N'[dbo].[ONOFFAUTO_DEFAULT]', @objname=N'[dbo].[DOM_ONOFFAUTO]' , @futureonly='futureonly'
GO
EXEC sys.sp_bindrule @rulename=N'[dbo].[ONOFFAUTO_RULE]', @objname=N'[dbo].[DOM_ONOFFAUTO]' , @futureonly='futureonly'
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_ITEMTYPE' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_ITEMTYPE] FROM [int] NULL
GO
EXEC sys.sp_bindefault @defname=N'[dbo].[ITEMTYPE_DEFAULT]', @objname=N'[dbo].[DOM_ITEMTYPE]' , @futureonly='futureonly'
GO
EXEC sys.sp_bindrule @rulename=N'[dbo].[ITEMTYPE_RULE]', @objname=N'[dbo].[DOM_ITEMTYPE]' , @futureonly='futureonly'
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_BIDTEKSORT' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_BIDTEKSORT] FROM [int] NULL
GO
EXEC sys.sp_bindefault @defname=N'[dbo].[BIDTEKSORT_DEFAULT]', @objname=N'[dbo].[DOM_BIDTEKSORT]' , @futureonly='futureonly'
GO
EXEC sys.sp_bindrule @rulename=N'[dbo].[BIDTEKSORT_RULE]', @objname=N'[dbo].[DOM_BIDTEKSORT]' , @futureonly='futureonly'
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_GROUPTYPE' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_GROUPTYPE] FROM [int] NULL
GO
EXEC sys.sp_bindefault @defname=N'[dbo].[GROUPTYPE_DEFAULT]', @objname=N'[dbo].[DOM_GROUPTYPE]' , @futureonly='futureonly'
GO
EXEC sys.sp_bindrule @rulename=N'[dbo].[GROUPTYPE_RULE]', @objname=N'[dbo].[DOM_GROUPTYPE]' , @futureonly='futureonly'
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_SURFACETYPE' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_SURFACETYPE] FROM [int] NULL
GO
EXEC sys.sp_bindefault @defname=N'[dbo].[SURFACETYPE_DEFAULT]', @objname=N'[dbo].[DOM_SURFACETYPE]' , @futureonly='futureonly'
GO
EXEC sys.sp_bindrule @rulename=N'[dbo].[SURFACETYPE_RULE]', @objname=N'[dbo].[DOM_SURFACETYPE]' , @futureonly='futureonly'
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_LOOKUPTYPE' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_LOOKUPTYPE] FROM [int] NULL
GO
EXEC sys.sp_bindefault @defname=N'[dbo].[LOOKUPTYPE_DEFAULT]', @objname=N'[dbo].[DOM_LOOKUPTYPE]' , @futureonly='futureonly'
GO
EXEC sys.sp_bindrule @rulename=N'[dbo].[LOOKUPTYPE_RULE]', @objname=N'[dbo].[DOM_LOOKUPTYPE]' , @futureonly='futureonly'
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_QUANTITYFROM' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_QUANTITYFROM] FROM [int] NULL
GO
EXEC sys.sp_bindefault @defname=N'[dbo].[QUANTITYFROM_DEFAULT]', @objname=N'[dbo].[DOM_QUANTITYFROM]' , @futureonly='futureonly'
GO
EXEC sys.sp_bindrule @rulename=N'[dbo].[QUANTITYFROM_RULE]', @objname=N'[dbo].[DOM_QUANTITYFROM]' , @futureonly='futureonly'
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_DESCALIGN' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_DESCALIGN] FROM [int] NULL
GO
EXEC sys.sp_bindefault @defname=N'[dbo].[DESCALIGN_DEFAULT]', @objname=N'[dbo].[DOM_DESCALIGN]' , @futureonly='futureonly'
GO
EXEC sys.sp_bindrule @rulename=N'[dbo].[DESCALIGN_RULE]', @objname=N'[dbo].[DOM_DESCALIGN]' , @futureonly='futureonly'
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_TAXCLASS' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_TAXCLASS] FROM [int] NULL
GO
EXEC sys.sp_bindefault @defname=N'[dbo].[TAXCLASS_DEFAULT]', @objname=N'[dbo].[DOM_TAXCLASS]' , @futureonly='futureonly'
GO
EXEC sys.sp_bindrule @rulename=N'[dbo].[TAXCLASS_RULE]', @objname=N'[dbo].[DOM_TAXCLASS]' , @futureonly='futureonly'
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_REPORTTYPE' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_REPORTTYPE] FROM [int] NULL
GO
EXEC sys.sp_bindefault @defname=N'[dbo].[REPORTTYPE_DEFAULT]', @objname=N'[dbo].[DOM_REPORTTYPE]' , @futureonly='futureonly'
GO
EXEC sys.sp_bindrule @rulename=N'[dbo].[REPORTTYPE_RULE]', @objname=N'[dbo].[DOM_REPORTTYPE]' , @futureonly='futureonly'
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_DIVISION' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_DIVISION] FROM [int] NULL
GO
EXEC sys.sp_bindefault @defname=N'[dbo].[DIVISION_DEFAULT]', @objname=N'[dbo].[DOM_DIVISION]' , @futureonly='futureonly'
GO
EXEC sys.sp_bindrule @rulename=N'[dbo].[DIVISION_RULE]', @objname=N'[dbo].[DOM_DIVISION]' , @futureonly='futureonly'
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_PROFITMETHOD' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_PROFITMETHOD] FROM [int] NULL
GO
EXEC sys.sp_bindefault @defname=N'[dbo].[PROFITMETHOD_DEFAULT]', @objname=N'[dbo].[DOM_PROFITMETHOD]' , @futureonly='futureonly'
GO
EXEC sys.sp_bindrule @rulename=N'[dbo].[PROFITMETHOD_RULE]', @objname=N'[dbo].[DOM_PROFITMETHOD]' , @futureonly='futureonly'
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_BOOLEAN' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_BOOLEAN] FROM [varchar](1) NOT NULL
GO
EXEC sys.sp_bindefault @defname=N'[dbo].[BOOLEAN_DEFAULT]', @objname=N'[dbo].[DOM_BOOLEAN]' , @futureonly='futureonly'
GO
EXEC sys.sp_bindrule @rulename=N'[dbo].[BOOLEAN_RULE]', @objname=N'[dbo].[DOM_BOOLEAN]' , @futureonly='futureonly'
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_CREWSIZEMETHOD' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_CREWSIZEMETHOD] FROM [int] NULL
GO
EXEC sys.sp_bindefault @defname=N'[dbo].[CREWSIZEMETHOD_DEFAULT]', @objname=N'[dbo].[DOM_CREWSIZEMETHOD]' , @futureonly='futureonly'
GO
EXEC sys.sp_bindrule @rulename=N'[dbo].[CREWSIZEMETHOD_RULE]', @objname=N'[dbo].[DOM_CREWSIZEMETHOD]' , @futureonly='futureonly'
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_UOM' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_UOM] FROM [int] NULL
GO
EXEC sys.sp_bindefault @defname=N'[dbo].[UOM_DEFAULT]', @objname=N'[dbo].[DOM_UOM]' , @futureonly='futureonly'
GO
EXEC sys.sp_bindrule @rulename=N'[dbo].[UOM_RULE]', @objname=N'[dbo].[DOM_UOM]' , @futureonly='futureonly'
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_UNITPRICEBY' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_UNITPRICEBY] FROM [int] NULL
GO
EXEC sys.sp_bindefault @defname=N'[dbo].[UNITPRICEBY_DEFAULT]', @objname=N'[dbo].[DOM_UNITPRICEBY]' , @futureonly='futureonly'
GO
EXEC sys.sp_bindrule @rulename=N'[dbo].[UNITPRICEBY_RULE]', @objname=N'[dbo].[DOM_UNITPRICEBY]' , @futureonly='futureonly'
GO
IF NOT EXISTS (SELECT * FROM sys.types st JOIN sys.schemas ss ON st.schema_id = ss.schema_id WHERE st.name = N'DOM_TIMBERLINESORT' AND ss.name = N'dbo')
CREATE TYPE [dbo].[DOM_TIMBERLINESORT] FROM [int] NULL
GO
EXEC sys.sp_bindefault @defname=N'[dbo].[TIMBERLINESORT_DEFAULT]', @objname=N'[dbo].[DOM_TIMBERLINESORT]' , @futureonly='futureonly'
GO
EXEC sys.sp_bindrule @rulename=N'[dbo].[TIMBERLINESORT_RULE]', @objname=N'[dbo].[DOM_TIMBERLINESORT]' , @futureonly='futureonly'
November 14, 2007 at 1:28 am
mrroofer (11/13/2007)
USE [master]GO
...CREATE USER [markr] FOR LOGIN [mroney] ...
this is wrong, it should be twice [markr]
it should be
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
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
Viewing 15 posts - 1 through 15 (of 23 total)
You must be logged in to reply to this topic. Login to reply