Showing posts with label properties. Show all posts
Showing posts with label properties. Show all posts

Friday, March 23, 2012

I can't change my sql login user's password in SQL Server 2005 Express

SQL Server 2005 Express keeps putting in a different password than the one I chose. I would check the properties on the login I want to change. Then I change the password and it gets accepted. When I try my web application, I get the dreaded "login failed for <loginname>". I look at the properties again and see my password never change. Is this a bug? I ever tried this syntax to no avail:

CREATE LOGIN <loginname> WITH PASSWORD='<mypassword>' CHECK_EXPIRATION = OFF, CHECK_POLICY = OFF

Can you provide some additional information, such as:

- what is the version of the operating system that you are working on?
- how do you check the login password - how do you know it was not set properly? what properties are you checking?

If you get a "Login failed" error, check the SQL Server errorlog as well. It should contain an error state, which can provide additional information on the cause of the error. Please post that error code so that we can determine if the failure is caused by using an incorrect password or some other reason.

Thanks
Laurentiu

|||

In addition to that, the error codes can span a various set of numbers, depending on the error got back. Even in the SQL Server 2005, there are many codes concerning the security features:
Look in here:
http://msdn2.microsoft.com/library/ms131024.aspx

HTH, Jens Suessmeyer.

Wednesday, March 21, 2012

I can't change my sql login user's password in SQL Server 2005 Express

SQL Server 2005 Express keeps putting in a different password than the one I chose. I would check the properties on the login I want to change. Then I change the password and it gets accepted. When I try my web application, I get the dreaded "login failed for <loginname>". I look at the properties again and see my password never change. Is this a bug? I ever tried this syntax to no avail:

CREATE LOGIN <loginname> WITH PASSWORD='<mypassword>' CHECK_EXPIRATION = OFF, CHECK_POLICY = OFF

Can you provide some additional information, such as:

- what is the version of the operating system that you are working on?
- how do you check the login password - how do you know it was not set properly? what properties are you checking?

If you get a "Login failed" error, check the SQL Server errorlog as well. It should contain an error state, which can provide additional information on the cause of the error. Please post that error code so that we can determine if the failure is caused by using an incorrect password or some other reason.

Thanks
Laurentiu

|||

In addition to that, the error codes can span a various set of numbers, depending on the error got back. Even in the SQL Server 2005, there are many codes concerning the security features:
Look in here:
http://msdn2.microsoft.com/library/ms131024.aspx

HTH, Jens Suessmeyer.

I can't add a user in "Security/Logins"

Under Security - Logins, right-click the user and hit properties. (IN
SQL 2000)Go to the database access tab, select the db you want to grant
access to then give the rights below. By default, you only grant
public.
natasha wrote:
> Good morning everyone,
> I've a user listed in "Security/Logins".
> If I right/click a database, Properties, "Permission" tab, I can't "Add" i
t
> to database's "Users or roles": if I "Browse" for users, it isn't listed.
How
> can I add?Yes, and in SQL 2005 "database access" tab has been substituted by "User
mapping" tab. But, owner of the database is dbo, and differently from other
DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
Is there any way to force a "take ownership" of the database?
"PSPDBA" ha scritto:

> Under Security - Logins, right-click the user and hit properties. (IN
> SQL 2000)Go to the database access tab, select the db you want to grant
> access to then give the rights below. By default, you only grant
> public.
> natasha wrote:
>|||Good morning everyone,
I've a user listed in "Security/Logins".
If I right/click a database, Properties, "Permission" tab, I can't "Add" it
to database's "Users or roles": if I "Browse" for users, it isn't listed. Ho
w
can I add?|||Under Security - Logins, right-click the user and hit properties. (IN
SQL 2000)Go to the database access tab, select the db you want to grant
access to then give the rights below. By default, you only grant
public.
natasha wrote:
> Good morning everyone,
> I've a user listed in "Security/Logins".
> If I right/click a database, Properties, "Permission" tab, I can't "Add" i
t
> to database's "Users or roles": if I "Browse" for users, it isn't listed.
How
> can I add?|||Yes, and in SQL 2005 "database access" tab has been substituted by "User
mapping" tab. But, owner of the database is dbo, and differently from other
DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
Is there any way to force a "take ownership" of the database?
"PSPDBA" ha scritto:

> Under Security - Logins, right-click the user and hit properties. (IN
> SQL 2000)Go to the database access tab, select the db you want to grant
> access to then give the rights below. By default, you only grant
> public.
> natasha wrote:
>|||Have you tried using the following stored procedure on the database where yo
u
wnat the user to have access to:
EXEC sp_adduser 'loginname', 'username'
See if that works or give any error?
Lucas
"natasha" wrote:
[vbcol=seagreen]
> Yes, and in SQL 2005 "database access" tab has been substituted by "User
> mapping" tab. But, owner of the database is dbo, and differently from othe
r
> DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
> Is there any way to force a "take ownership" of the database?
>
> "PSPDBA" ha scritto:
>|||Have you tried using the following stored procedure on the database where yo
u
wnat the user to have access to:
EXEC sp_adduser 'loginname', 'username'
See if that works or give any error?
Lucas
"natasha" wrote:
[vbcol=seagreen]
> Yes, and in SQL 2005 "database access" tab has been substituted by "User
> mapping" tab. But, owner of the database is dbo, and differently from othe
r
> DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
> Is there any way to force a "take ownership" of the database?
>
> "PSPDBA" ha scritto:
>|||I tried to, and I've quite a curious error:
Msg 15063, Level 16, State 1, Line 1
The login already has an account under a different user name.
"Lucas Kartawidjaja" ha scritto:
[vbcol=seagreen]
> Have you tried using the following stored procedure on the database where
you
> wnat the user to have access to:
> EXEC sp_adduser 'loginname', 'username'
> See if that works or give any error?
> Lucas
> "natasha" wrote:
>|||> Is there any way to force a "take ownership" of the database?
sp_changedbowner
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"natasha" <natasha@.discussions.microsoft.com> wrote in message
news:FBFC25FE-C6C8-4B8E-A769-419169EF1DDB@.microsoft.com...[vbcol=seagreen]
> Yes, and in SQL 2005 "database access" tab has been substituted by "User
> mapping" tab. But, owner of the database is dbo, and differently from othe
r
> DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
> Is there any way to force a "take ownership" of the database?
>
> "PSPDBA" ha scritto:
>|||I tried to, and I've quite a curious error:
Msg 15063, Level 16, State 1, Line 1
The login already has an account under a different user name.
"Lucas Kartawidjaja" ha scritto:
[vbcol=seagreen]
> Have you tried using the following stored procedure on the database where
you
> wnat the user to have access to:
> EXEC sp_adduser 'loginname', 'username'
> See if that works or give any error?
> Lucas
> "natasha" wrote:
>sql

I can't add a user in "Security/Logins"

Good morning everyone,
I've a user listed in "Security/Logins".
If I right/click a database, Properties, "Permission" tab, I can't "Add" it
to database's "Users or roles": if I "Browse" for users, it isn't listed. How
can I add?Under Security - Logins, right-click the user and hit properties. (IN
SQL 2000)Go to the database access tab, select the db you want to grant
access to then give the rights below. By default, you only grant
public.
natasha wrote:
> Good morning everyone,
> I've a user listed in "Security/Logins".
> If I right/click a database, Properties, "Permission" tab, I can't "Add" it
> to database's "Users or roles": if I "Browse" for users, it isn't listed. How
> can I add?|||Yes, and in SQL 2005 "database access" tab has been substituted by "User
mapping" tab. But, owner of the database is dbo, and differently from other
DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
Is there any way to force a "take ownership" of the database?
"PSPDBA" ha scritto:
> Under Security - Logins, right-click the user and hit properties. (IN
> SQL 2000)Go to the database access tab, select the db you want to grant
> access to then give the rights below. By default, you only grant
> public.
> natasha wrote:
> > Good morning everyone,
> > I've a user listed in "Security/Logins".
> > If I right/click a database, Properties, "Permission" tab, I can't "Add" it
> > to database's "Users or roles": if I "Browse" for users, it isn't listed. How
> > can I add?
>|||Have you tried using the following stored procedure on the database where you
wnat the user to have access to:
EXEC sp_adduser 'loginname', 'username'
See if that works or give any error?
Lucas
"natasha" wrote:
> Yes, and in SQL 2005 "database access" tab has been substituted by "User
> mapping" tab. But, owner of the database is dbo, and differently from other
> DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
> Is there any way to force a "take ownership" of the database?
>
> "PSPDBA" ha scritto:
> > Under Security - Logins, right-click the user and hit properties. (IN
> > SQL 2000)Go to the database access tab, select the db you want to grant
> > access to then give the rights below. By default, you only grant
> > public.
> >
> > natasha wrote:
> > > Good morning everyone,
> > > I've a user listed in "Security/Logins".
> > > If I right/click a database, Properties, "Permission" tab, I can't "Add" it
> > > to database's "Users or roles": if I "Browse" for users, it isn't listed. How
> > > can I add?
> >
> >|||I tried to, and I've quite a curious error:
Msg 15063, Level 16, State 1, Line 1
The login already has an account under a different user name.
"Lucas Kartawidjaja" ha scritto:
> Have you tried using the following stored procedure on the database where you
> wnat the user to have access to:
> EXEC sp_adduser 'loginname', 'username'
> See if that works or give any error?
> Lucas
> "natasha" wrote:
> > Yes, and in SQL 2005 "database access" tab has been substituted by "User
> > mapping" tab. But, owner of the database is dbo, and differently from other
> > DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
> > Is there any way to force a "take ownership" of the database?
> >
> >
> >
> > "PSPDBA" ha scritto:
> >
> > > Under Security - Logins, right-click the user and hit properties. (IN
> > > SQL 2000)Go to the database access tab, select the db you want to grant
> > > access to then give the rights below. By default, you only grant
> > > public.
> > >
> > > natasha wrote:
> > > > Good morning everyone,
> > > > I've a user listed in "Security/Logins".
> > > > If I right/click a database, Properties, "Permission" tab, I can't "Add" it
> > > > to database's "Users or roles": if I "Browse" for users, it isn't listed. How
> > > > can I add?
> > >
> > >|||> Is there any way to force a "take ownership" of the database?
sp_changedbowner
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"natasha" <natasha@.discussions.microsoft.com> wrote in message
news:FBFC25FE-C6C8-4B8E-A769-419169EF1DDB@.microsoft.com...
> Yes, and in SQL 2005 "database access" tab has been substituted by "User
> mapping" tab. But, owner of the database is dbo, and differently from other
> DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
> Is there any way to force a "take ownership" of the database?
>
> "PSPDBA" ha scritto:
>> Under Security - Logins, right-click the user and hit properties. (IN
>> SQL 2000)Go to the database access tab, select the db you want to grant
>> access to then give the rights below. By default, you only grant
>> public.
>> natasha wrote:
>> > Good morning everyone,
>> > I've a user listed in "Security/Logins".
>> > If I right/click a database, Properties, "Permission" tab, I can't "Add" it
>> > to database's "Users or roles": if I "Browse" for users, it isn't listed. How
>> > can I add?
>>|||Hmm... interesting.
I think you might want to try to run the following script on the database
that the user need to access:
EXEC sp_dropuser 'username'
GO
and then run the:
EXEC sp_adduser 'loginname', 'username'
GO
see if that works.
Lucas
"natasha" wrote:
> I tried to, and I've quite a curious error:
> Msg 15063, Level 16, State 1, Line 1
> The login already has an account under a different user name.
>
>
>
> "Lucas Kartawidjaja" ha scritto:
> > Have you tried using the following stored procedure on the database where you
> > wnat the user to have access to:
> > EXEC sp_adduser 'loginname', 'username'
> >
> > See if that works or give any error?
> >
> > Lucas
> >
> > "natasha" wrote:
> >
> > > Yes, and in SQL 2005 "database access" tab has been substituted by "User
> > > mapping" tab. But, owner of the database is dbo, and differently from other
> > > DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
> > > Is there any way to force a "take ownership" of the database?
> > >
> > >
> > >
> > > "PSPDBA" ha scritto:
> > >
> > > > Under Security - Logins, right-click the user and hit properties. (IN
> > > > SQL 2000)Go to the database access tab, select the db you want to grant
> > > > access to then give the rights below. By default, you only grant
> > > > public.
> > > >
> > > > natasha wrote:
> > > > > Good morning everyone,
> > > > > I've a user listed in "Security/Logins".
> > > > > If I right/click a database, Properties, "Permission" tab, I can't "Add" it
> > > > > to database's "Users or roles": if I "Browse" for users, it isn't listed. How
> > > > > can I add?
> > > >
> > > >

Friday, February 24, 2012

hyperlink open new window

I have a link on my report which open new window. The code i have in advance properties of that field is :

="javascriptt:void(window.open('http://www.msn.com','_blank'))" (note: the extra "t" is intentionally added in the code, coz website block the keyword "java.....t")

It works great on testing server but it doesn't work on production server. Both testing and production servers run windows 2003 server and service pack 2 for reporting services.

Reports accessing form production server, when i click on report it opens up new window with address in address bar :

javascript:void(window.open('http://www.msn.com','_blank')) with "The page cannot be displayed" message. But if i open a new internet explorer window and copy past the same address in address bar then its open up www.msn.com. To test the production server behavior I created a test web page test.htm and added the java script to open new window, it works fine.

Any help would be much appreciated.

Ive had problems with this too!
I found it only works when you access the report via a URL such as
http://reportserver/reportserver?report
Rather than through the Report Manager:
http://reportserver/reports
Through the Report Manager I saw the same behaiviour "The page cannot be displayed" message but copying and pasting worked :S
Although Im not surew this is your problem as it works on your tst server, but not prod
Hope this helps
Al