Re: Fresh installation and no access

ok. i ran the query and got 1 as a result.

but how can I change this setting if I dont have any permission?

Stig

"Uri Dimant" <urid@xxxxxxxxxxx> wrote in message news:uo6brH$MHHA.1240@xxxxxxxxxxxxxxxxxxxxxxx
Sure
SELECT SERVERPROPERTY('IsIntegratedSecurityOnly') AS

[IsIntegratedSecurityOnly]









"Stig Kulvedrøsten" <stig@xxxxxxxx> wrote in message news:D25D73BE-1B57-4A7D-9509-52E48E9322C7@xxxxxxxxxxxxxxxx
I thought I set it to Mixed Authentication but now I'm not sure. Is there any way to change this setting without reinstalling it?

"Uri Dimant" <urid@xxxxxxxxxxx> wrote in message news:eGrlvS%23MHHA.4928@xxxxxxxxxxxxxxxxxxxxxxx
Stig

During the instalation process, did you set up SQL Server to Windows only or Mixed Authentication?
I don't have Windows Vista to test the problem, sorry.




"Stig Kulvedrøsten" <stig@xxxxxxxx> wrote in message news:EE6F52D2-732E-4A27-8285-3B613E1AA262@xxxxxxxxxxxxxxxx
I've just installed MS SQL Server Express Advanced Editon and when loggin in with my user account(using Widnows Vista) I have no permission at all. I cant create a new database and I cant change any settings. Then I tried logging on with the sa account. Then I got this error message:

TITLE: Connect to Server
------------------------------

Cannot connect to KULVIS\SQLEXPRESS.

------------------------------
ADDITIONAL INFORMATION:

Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18452&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Stig






.

Relevant Pages

  • Re: Newbie needs code pages for SQL Server 2000 access from asp.net page using vb.net
    ... It would make more sense if the error message described that permission was ... I am not sure what user to add where in IIS ... >> passing SQL server the account used to run the website. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Unable to Connect to an external data source.
    ... - ms sql server 2005 ... For assistance, contact your site administrator. ... I get the error message: You do not have permission to connect ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Column Level Permissions Security Issue
    ... role is granted SELECT rights as in "GRANT SELECT TO RWE", then a DENY ... When working with security in SQL Server it's imperative to understand ... discusses ownership chaining: http://www.sommarskog.se/dynamic_sql.html. ... there are users who have permission to access this ...
    (microsoft.public.sqlserver.security)
  • Re: SQL CLR Sproc isnt running right
    ... did you grant rights using the SQL Server 2005 Surface Area Config tool? ... and I got a permissions error back saying DBO doesn't have permission to insert records into the table... ... but the assemblie's stored procedures do all have execute permissions set for the role that the executing user is in... ... "William Vaughn" wrote in message ...
    (microsoft.public.dotnet.framework.adonet)
  • System.Security.SecurityException with .NET 2005 Only
    ... Crystal Report from a SQL Server 2000 table. ... Friend WithEvents scnSQLConnection As _ ... The dialog box suggests clicking on "Add Permission to the Project." ... Restart the debugging session, same problem again. ...
    (microsoft.public.dotnet.languages.vb)