Viewing 15 posts - 5,461 through 5,475 (of 7,505 total)
You've got the solution.
Just a reminder there are some downsides for using dynamic sql
All time ref: http://www.sommarskog.se/dynamic_sql.html :Whistling:
November 16, 2007 at 4:55 am
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...
November 15, 2007 at 12:01 am
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
November 14, 2007 at 4:10 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...
November 14, 2007 at 1:28 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',...
November 13, 2007 at 6:45 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...
November 13, 2007 at 4:01 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...
November 13, 2007 at 12:10 am
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...
November 12, 2007 at 1:10 pm
just to add..
Make sure you have indexes that exactly match your FK-definition in the dependant table(s). (column order, column sorting order (asc/desc))
November 11, 2007 at 6:30 am
did someone alter the original northwind database to be readonly ?
perform on your sql2k :
alter database northwind set read_write;
Then stop the sql2000 instance or detatch northwind db, copy it to...
November 10, 2007 at 3:50 am
check out http://msdn2.microsoft.com/en-us/library/ms124425.aspx
it explains it all.
In this case datatype name is an alias data type.
November 9, 2007 at 1:38 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.
November 9, 2007 at 1:33 pm
maybe you can use these scripts to diagnose the problem :
http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31867/
or even my article http://www.sqlservercentral.com/articles/Service+Broker/2897/
November 9, 2007 at 12:52 pm
one of the top 3 rules for any rdbms: use the correct datatype !
If you know it concerns a date / time / datetime column, use the datetime datatype !...
November 9, 2007 at 12:45 pm
Viewing 15 posts - 5,461 through 5,475 (of 7,505 total)