SQL About AMO: mode

Showing posts with label mode. Show all posts

Monday, March 19, 2012

Access - restrict access issue

Hi,
I seems to having this issue that a database is changing itself on the
access rights to a 'restrict access for single user mode'.
Basically I did not do anything to change that mode, but may I know if there
is any way that I can prevent it changing to the single user mode? Currently
I'm not having any access restriction setup in the 'Access' under property
page of the database.
FYI, I'm using MSSQL 2K - sp4.
Please advice.
It could be a maintenance plan. If you use them, look at the
integrity checks and make sure to uncheck the "attempt to
repair any minor problem" option.
-Sue
On Thu, 23 Feb 2006 17:29:02 -0800, "seal_cet"
<seal_cet@.discussions.microsoft.com> wrote:

>Hi,
>I seems to having this issue that a database is changing itself on the
>access rights to a 'restrict access for single user mode'.
>Basically I did not do anything to change that mode, but may I know if there
>is any way that I can prevent it changing to the single user mode? Currently
>I'm not having any access restriction setup in the 'Access' under property
>page of the database.
>FYI, I'm using MSSQL 2K - sp4.
>Please advice.

Access - restrict access issue

Hi,
I seems to having this issue that a database is changing itself on the
access rights to a 'restrict access for single user mode'.
Basically I did not do anything to change that mode, but may I know if there
is any way that I can prevent it changing to the single user mode? Currently
I'm not having any access restriction setup in the 'Access' under property
page of the database.
FYI, I'm using MSSQL 2K - sp4.
Please advice.It could be a maintenance plan. If you use them, look at the
integrity checks and make sure to uncheck the "attempt to
repair any minor problem" option.
-Sue
On Thu, 23 Feb 2006 17:29:02 -0800, "seal_cet"
<seal_cet@.discussions.microsoft.com> wrote:
>Hi,
>I seems to having this issue that a database is changing itself on the
>access rights to a 'restrict access for single user mode'.
>Basically I did not do anything to change that mode, but may I know if there
>is any way that I can prevent it changing to the single user mode? Currently
>I'm not having any access restriction setup in the 'Access' under property
>page of the database.
>FYI, I'm using MSSQL 2K - sp4.
>Please advice.

Sunday, February 19, 2012

About server authentication

Hi,
I've enabled the SQL Server and Windows Authentication mode, and then I
restarted the SQL server. My ASP.NET program can be access the server, but I
found that I cannot login the SQL server using Microsoft SQL Server
Management Studio.
I checked the ERRORLOG on my server, which shows following information. I'm
sure my password is correct.
Logon Error: 18456, Severity: 14, State: 8.
Logon Login failed for user 'sa'. [CLIENT: <named pipe>]
Logon Error: 18456, Severity: 14, State: 8.
Logon Login failed for user 'sa'. [CLIENT: <local machine>]
Error: 18456, Severity: 14, State: 8.
Login failed for user 'sa'. [CLIENT: 192.168.200.1]
Any suggestion for it?
Many thanks~Are you on 2005? If so, is the "sa" account disabled?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Daatmor" <daatmor@.mail.hongkong.com> wrote in message news:OBphWWyWHHA.4028@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I've enabled the SQL Server and Windows Authentication mode, and then I restarted the SQL server.
> My ASP.NET program can be access the server, but I found that I cannot login the SQL server using
> Microsoft SQL Server Management Studio.
> I checked the ERRORLOG on my server, which shows following information. I'm sure my password is
> correct.
> Logon Error: 18456, Severity: 14, State: 8.
> Logon Login failed for user 'sa'. [CLIENT: <named pipe>]
> Logon Error: 18456, Severity: 14, State: 8.
> Logon Login failed for user 'sa'. [CLIENT: <local machine>]
> Error: 18456, Severity: 14, State: 8.
> Login failed for user 'sa'. [CLIENT: 192.168.200.1]
> Any suggestion for it?
> Many thanks~
>|||Yes, I'm using SQL Server 2005, and enabled the "sa" account.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23eA$s%23yWHHA.1396@.TK2MSFTNGP05.phx.gbl...
> Are you on 2005? If so, is the "sa" account disabled?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Daatmor" <daatmor@.mail.hongkong.com> wrote in message
> news:OBphWWyWHHA.4028@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> I've enabled the SQL Server and Windows Authentication mode, and then I
>> restarted the SQL server. My ASP.NET program can be access the server,
>> but I found that I cannot login the SQL server using Microsoft SQL Server
>> Management Studio.
>> I checked the ERRORLOG on my server, which shows following information.
>> I'm sure my password is correct.
>> Logon Error: 18456, Severity: 14, State: 8.
>> Logon Login failed for user 'sa'. [CLIENT: <named pipe>]
>> Logon Error: 18456, Severity: 14, State: 8.
>> Logon Login failed for user 'sa'. [CLIENT: <local machine>]
>> Error: 18456, Severity: 14, State: 8.
>> Login failed for user 'sa'. [CLIENT: 192.168.200.1]
>> Any suggestion for it?
>> Many thanks~
>|||Next step would be to change the password for sa to something known, I guess.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Daatmor" <daatmor@.mail.hongkong.com> wrote in message news:ORVoiO6WHHA.1432@.TK2MSFTNGP02.phx.gbl...
> Yes, I'm using SQL Server 2005, and enabled the "sa" account.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:%23eA$s%23yWHHA.1396@.TK2MSFTNGP05.phx.gbl...
>> Are you on 2005? If so, is the "sa" account disabled?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Daatmor" <daatmor@.mail.hongkong.com> wrote in message
>> news:OBphWWyWHHA.4028@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> I've enabled the SQL Server and Windows Authentication mode, and then I restarted the SQL
>> server. My ASP.NET program can be access the server, but I found that I cannot login the SQL
>> server using Microsoft SQL Server Management Studio.
>> I checked the ERRORLOG on my server, which shows following information. I'm sure my password is
>> correct.
>> Logon Error: 18456, Severity: 14, State: 8.
>> Logon Login failed for user 'sa'. [CLIENT: <named pipe>]
>> Logon Error: 18456, Severity: 14, State: 8.
>> Logon Login failed for user 'sa'. [CLIENT: <local machine>]
>> Error: 18456, Severity: 14, State: 8.
>> Login failed for user 'sa'. [CLIENT: 192.168.200.1]
>> Any suggestion for it?
>> Many thanks~
>>
>

About server authentication

Thursday, February 9, 2012

About AMO

I write web service with .NET 2.0.

It's using AMO to connect SQL Server 2005 and show counts of database.

When I excute the program under debug mode in my computer for testing,it's showing the correct counts.

But when I establish this web in the server,and browse it to use, the showing counts is zero.

Could some tell me why?

Thanks~

Server OS: Windows 2003

My Computer OS: Windows XP

follow is program:

Code Snippet

<WebMethod()> _
Public Function Test() As String
Dim ConnectServer As New Server
Dim tmp As String
ConnectServer.Connect("Data Source = olapdw;Provider = MSOLAP;")

tmp = ConnectServer.Databases.Count
ConnectServer.Disconnect()
ConnectServer.Dispose()
Return tmp

End Function

It's most likely a security / authentication issue. AMO uses windows authentication, so running on your local machine might be running under your account. So it probably depends on what account is configured to run the application pool that your web service is running under. You can set up impersonation, but if the web service and IIS are on separate machines, you need to configure Kerberos authentication.

You also do not use a connection string for AMO, the connect string only needs a server name.

eg.

ConnectServer.Connect("olapdw")

|||

Thanks, my problem has already resolved.

It's the same like following link

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2037078&SiteID=1&mode=1

About AMO

I write web service with .NET 2.0.

It's using AMO to connect SQL Server 2005 and show counts of database.

When I excute the program under debug mode in my computer for testing,it's showing the correct counts.

But when I establish this web in the server,and browse it to use, the showing counts is zero.

Could some tell me why?

Thanks~

Server OS: Windows 2003

My Computer OS: Windows XP

follow is program:

Code Snippet

<WebMethod()> _
Public Function Test() As String
Dim ConnectServer As New Server
Dim tmp As String
ConnectServer.Connect("Data Source = olapdw;Provider = MSOLAP;")

tmp = ConnectServer.Databases.Count
ConnectServer.Disconnect()
ConnectServer.Dispose()
Return tmp

End Function

You also do not use a connection string for AMO, the connect string only needs a server name.

eg.

ConnectServer.Connect("olapdw")

|||

Thanks, my problem has already resolved.

It's the same like following link

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2037078&SiteID=1&mode=1

Monday, March 19, 2012

Access - restrict access issue

Access - restrict access issue

Sunday, February 19, 2012

About server authentication

About server authentication

About server authentication

Thursday, February 9, 2012

About AMO

About AMO

SQL About AMO

Blog Archive

About Me