Viewing 15 posts - 5,461 through 5,475 (of 7,502 total)
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...
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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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
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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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',...
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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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))
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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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...
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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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.
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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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.
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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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/
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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
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 !...
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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
November 9, 2007 at 12:45 pm
Is there any reason why it shouldn't be ?
If you can connect to a source, you can (bulk) insert from it.
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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
November 9, 2007 at 12:41 pm
John Diss (11/6/2007)
I have seen situations where query hints were vital. see ..
indeed, but that should not be a general practise
and these cases' hint accuracy should be re-evaluated often.
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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
November 6, 2007 at 6:38 am
Viewing 15 posts - 5,461 through 5,475 (of 7,502 total)