Setting Permissions In Sql Server 2005 For Asp User Account

May 15, 2006

How would Set permissions
  Sql
  Server 2005 so that I can access a
  asp page created in VWD and Sql Express.
 
On the production server i have just the one instance of Sql
 
I have the following connection string in the web config file:

 

<
connectionStrings
>


        <
add

name
=
"
ConnectionString"

connectionString
="
server=serversNameXPRESS;uid=aspuser;pwd=aspuserPassworkd;database=DATABName"
/>


    </
connectionStrings
>
 
The account i setup to access the db in Sql 2005 Proper on the Production serve is Represented by the name in the above example as “aspuser�. I created this user in security, logins. And
  I gave permissions to this on the Db level “create procedure
  delete, select, update insert.â€?
 
I get a error when i run the page in the browser that
  says “login failed for aspuser.â€?
 
I know virtual directory is configured properly. I can run aspx page in the directory with out a db connection, without and error.
 
Any help would be greatly appreciated.

View 2 Replies


ADVERTISEMENT

Permissions For Domain User Account

Jun 8, 2007

Hi,
I want to use a domain user account not belonging to local admin or domain admin groups in SQL 2000/2005 Enterprise edition. This is what I've done so far..
On the machine that is the Domain Controller:
- installed SQL 2005 as a domain admin

- created a domain user account using Active Directory Users and Computers. This user is only


"Member of" domain users; not any Administrators group.


- added this user to SQL Server Management Studio->Logins and in Server Roles assigned


sysadmin role.
Question 1: Do I need to give any additional permissions to this user to work with SQL?
Question 2: How can I test this user for basic SQL operations like database creation? Can I use Osql?
Question 3: Can I use this user account to login to my domain controller using remote desktop? I tried adding this user to remote users, but in vain.



Thanks!

View 3 Replies View Related

Failure Setting Security Rights On User Account SQLServer2005BrowserUser${computerName}

May 29, 2007

I'm trying to install SQL Server 2005 Express on a Windows 2000 server, but I'm getting the following error message:



"Failure setting security rights on user account SQLServer2005BrowserUser${computerName}"



Can anyone help me please?



View 1 Replies View Related

Easily Setting Permissions For Many Objects For 1 User

Aug 12, 1998

If I want to easily and quickly grant all permissions to a group of objects
for one user (or group), how can I do this with the tools provided?

In 6.5, I could right-click the user or group and click the "Grant All" button.

In 7.0 this is either missing or has been moved.

Thanks!

Jim

View 1 Replies View Related

SQL Server 2005 Agent - User Account

Jun 26, 2007

Who needs to invoke the jobs in SQL05? Manually executing the job import_myteam as a user with dbo privileges fails. So, which user account should be assigned to successfully run scheduled jobs (ie, dbo)?

The package file for the job in question is located in the server€™s C:Documents and SettingsuserxyzMy DocumentsVisual Studio 2005ProjectsIntegration Services Project3Integration Services Project3MyTeam (1).dtsx, but this still fails when the user userxyz is logged on and is executing the job directly from the server console.

Step1 of the package executes as userxyz
Step 2 fails and runs as cpmc-casql02

The user account userxyz has administrator rights to the server as well as being a sysadmin of the SQL2005 database (named cpcasql02).

The account cpmc-casql02 is a €œpublic€? user of the database and is a member of the administrator group on the server itself.

This same scenario carries for tasks as simple as truncating a table and importing the contents of another table in the same database.

All of these jobs exhibit the same behavior whether run directly from the server console on remotely from a workstation connected to the SQL2005 database.

Attempting to get a really simple job working, we also created a very simple SSIS package which does a select from a database table and writes the output to a text file. When running the same package from the user€™s workstation within Visual Studio, the package executes successfully. Once copied to the server, and run from within SQLServer as MyJunePackage however, the execution fails in the same manner as described above. The first step executes successfully as the logged-in user and the second fails executed under the account cpmc-casql02.

So, again we have the same behavior of sequential steps being run as different users with unsatisfactory results. Please advise as to how to set up these jobs to run correctly and consistently.

Thanks very much,Eric W

View 1 Replies View Related

NT AUTHORITYNETWORK_SERVICE Vs Local User Account In SQL-Server 2005

Aug 14, 2007

Hi all,

I've recently installed SQL-Server 2005 on our production server (win server r2, .net framework 2.0, 3.0 etc ..).
In order to improve the security mechanism I'm allowing only windows authentication (not mixed mode).

If each site and the sql-process is given a specific user account, could it have some bad performance issues ?
Security-wise, which is better ?

Few things to point out:
1. The SQL process was assigned with a local user account (i.e : [machine name]SqlServerUser) and not using NT AUTHORITYNETWORK_SERVICE.
2. Every ASP.Net site on the server assigned with a local account (i.e : [machine name]SomeSiteUser) through the IIS's Directory Security tab and not using IUSR_[machine name].
3. Each "Site User" has the appropriate database authorization in sql.
Any given help will be appreciated, thanks.

View 4 Replies View Related

MSSQL Server 2005 Reported Account Locked Out For User 'sa'

Nov 29, 2006

Greetings,

I receive an error message in event log when i try to connect to the Database Server using ODBC on a client machine. The database server is running on Windows 2003 Server Standard Edition and the client machine is Windows XP Professional. Following is the error message from the event log:

2147467259 - [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa' because the account is currently locked out. The system administrator can unlock it.

What causes the error to occur and how to resolve it?Appreciate for your assistence.

Thanks and regards,

Viknes

View 4 Replies View Related

Trouble Logging In To SQL Server 2005 Express With Domain User Account

Sep 22, 2006

Hi all,

I have a SQL Server 2005 Express edition instance set up on one server, and IIS on another server.

The SQL Server process account is a domain user account, which I have added to the local groups that SQL Server created during installation (I originally used a local user account instead of domain account; however, the problem occurs with both).

SQL Server runs fine, and if I set my IIS application pool identity to a domain admin, my web app can access the database and retrieve the data necessary.

However, I have a domain user account that I want to use to run the app pool and retrieve the data. The domain user account is added to the IIS_WPG group on the web server. On the database server, I have created a login for the account, as well as added it to the db_datareader role of the database that is used for the site.

However, the user is not able to connect to the SQL Server. I get the "Login failed for user <user account>" error in ASP.NET. I also tried connecting with SQL Server Management Studio, and I get the same error. I checked and the user has connect permission to the database server.

With admin accounts, there are no problems logging in, etc.

Any pointers are appreciated,

Thanks,

SA.

Edit: I was able to find out that the State is 11 for the error. According to http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx, this indicates "Valid login but server access failure." I am not sure how to resolve this.

View 1 Replies View Related

Permissions To A Local Account On Which SQL Server Service Works

Mar 31, 2006

My SQL Server 2005 runs on a local account. Is it neccesary to assign this login in SQL to a System Administrator role?

And is there any difference in SQL Server 2000?



thanks

Przemo

View 1 Replies View Related

SQL Server Admin 2014 :: Does Changing Service Account Update NTFS Permissions

Nov 22, 2014

If you were to do a fresh install it would set permissions on the disk so everything just works.

Now when changing the service account (e.g. to a domain user) use the configuration manager, does it do the same magic (possibly sans if the database data/log files are on another disk)? Or do you need to trawl through the dozens of folders and assign rights manually?

View 1 Replies View Related

How To See User Permissions In 2005...

Nov 2, 2007

In SQL/2000 EM I can go to a user Database, expand the Users, double click a user and click Permissions to see everything a user has permisson to in the database. How can I get the same information in Management Studio in SQL/2005? Is there an overview of this process in BOL 2005?

Thanks in advance!!!

DeWayne

View 3 Replies View Related

How To Script User & Object Permissions In 2005

Feb 8, 2008

Using Management Studio how do you script only user and object permissions? I don't want to script the corresponding "Create" statements for each object, only their permissions.

Thanks, Dave

View 4 Replies View Related

Windows Accounts And User Permissions In MSSQL EXPRESS 2005

May 15, 2008

This may be an idiotic question:

I am attempting to use Visual Web Developer Express with a connection to a SQL Express db from a non-admin account on my XP Pro SP2 machine.

I can do everything in the app under an admin login, but can't seem to configure the db to allow the non-admin account access to the db. I've tried tweaking WMI, using Network Service, Local Service, and Local System with NT AUTHORITY, individual logins, and group permissions, but I'm stuck.

Any thoughts?

View 5 Replies View Related

How Many People Can Login To SQL Server With The Same User Account?

Mar 8, 1999

I'm developing a client-server application using Visual Basic and SQL Server
6.5 for 700 users. The application currently requires users to login to the
database using their network account (via trusted connections). Each of the
users takes up a maximum of 6 connections. Unfortunately, other
considerations will force us to discard use of trusted connections. So it
only leaves us either to create 700 user accounts on SQL Server separately
from their network logins or to create one SQL Server account and everybody
uses that same account to login to the database. For political reasons, the
customer would prefer not to ask their support group to maintain 700 user
accounts on SQL Server if it can be avoided.

My question: is there any technical limitation or other negative consequence
of having 700 users login to the same account to SQL Server if SQL Server
can handle that many connections (it would be 6*700 = 4200 connections)
simultaneously? Are we supposed to do things like this? It seems that we
don’t have better choice than this.

View 1 Replies View Related

How To Use Sql Server In Limited Window User Account

Oct 16, 2006

Ankush Jain writes "I m using Sql Server 2000 in Windoes XP (SP2) with Limited Window Account.
I m new to Sql Server.Please You can tell me how to create database.
When i expand the console root in Enterprise Manager it will show an error : "A connection could not be established to Local""

View 2 Replies View Related

What Permissions Are Required For SQL Server Service Account To Call Web Service Using CLR Integration?

May 18, 2007

Hello! I have the following problem. I developed CLR Stored Procedure "StartNotification" and deploy it on db. This sp calls external web service. Furthermore, this sp is called according with SQL Server Agent Job's schedule. On my PC SQL Server works under Local System account and this web service is called correctly (Executed as user: NT AUTHORITYSYSTEM). But on ther other server the following exception is raised during job running:
Date 17.04.2007 16:42:10
Log Job History (FailureNotificationJob)

Step ID 1
Server MSK-CDBPO-01
Job Name FailureNotificationJob
Step Name MainStep
Duration 00:00:00
Sql Severity 16
Sql Message ID 6522
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: CORPmssqlserver.
A .NET Framework error occurred during execution
of user defined routine or aggregate 'StartNotification':
System.Security.SecurityException: Request for the permission of type
'System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089' failed. System.Security.SecurityException:
at System.Security.CodeAccessSecurityEngine.Check(Object demand,
StackCrawlMark& stackMark, Boolean isPermSet)
at System.Security.CodeAccessPermission.Demand()
at System.Net. The step failed.

What is the reason of this behaviour? Unfortunately I do not have direct access to this server.
I have the following guesses:
1) CORPmssqlserver may have not enough permissions to call web service
2) Something wrong with SQL Server account's permissions
2) Something wrong with SQL Server Agent account's permissions
I will take the will for the deed. Thanks.

View 1 Replies View Related

TempDb Drops User Account On Server Restart?

Sep 11, 2007

Please forgive my ignorance, I am by no means a SQL Expert, but have encountered a strange issue.

I have 6 SQL Servers, Primarily SQL 2005 (one older SQL 2000) all loaded on Windows Server 2003 SP1.

We use the servers for a proprietary database that we created which is the backend to a software package we sell.

The issue I have is: We have added a Security account to the servers, and in one case we have granted rights for this account to the TempDB system database. However, whenever we restart this server SQL drops this user account, thus severing connectivity for the app that is relying on that account.

I have set the account as DB-Owner etc, but nothing sems to keep it on re-start.

Any input would be greatly appreciated.

View 4 Replies View Related

Drop And Add A Sql Server Login Account To Each User Database

Dec 6, 2007



I would like to write code to delete and add a SQL Login to every User database on my development server.
Whenever I restore databases to dev using production backups the SQl Server logins are invalid and I need to delete them from the user database and add them again.

I've already hard-coded a sql server job with n steps... a step for each user database to drop and add this sql user to each database. This isn't optimal since I have to add or delete a step everytime a user database is added or deleted.

Does anyone know how to write a loop or cursor that does this dynamically?
I am doing something syntactically wrong related to the GO statement.




declare @db varchar(100)

declare @message varchar(3000)

DECLARE user_cursor CURSOR FOR

SELECT top 1 name

FROM master.sys.databases

where name not in

('master','tempdb','model','msdb')

OPEN user_cursor

FETCH NEXT FROM user_cursor INTO @db



WHILE @@FETCH_STATUS = 0

BEGIN

SELECT @message = 'use '+@db + '

GO'

+'DROP USER [SQLLogin.DataEntry]

CREATE USER [SQLLogin.DataEntry] FOR LOGIN [SQLLogin.DataEntry]

EXEC sp_addrolemember N''db_datareader'', N''SQLLogin.DataEntry''

GO

'

execute @message

print @message

FETCH NEXT FROM user_cursor INTO @db

END

CLOSE user_cursor

DEALLOCATE user_cursor





View 3 Replies View Related

SQL Service Account Permissions

Oct 2, 2007

I just set up a SQL 2005 Server about a month ago that we will be moving all of our scattered DBs onto. I basically set it up with the default settings and didn't touch anything special, until I tried to install Microsoft System Center Essentials 2007 in our environment. I had problems getting it to use our SQL server, and a forum post told me to change all of the service accounts for SQL to use the LocalSystem login. So here are my service accounts:

SQL Server Integration Services
- NT AUTHORITYNetworkService
SQL Server FullText Search (MSSQLSERVER)
- LocalSystem
SQL Server (MSSQLSERVER)
- LocalSystem
SQL Server Analysis Services (MSSQLSERVER)
- LocalSystem
SQL Server Reporting Services (MSSQLSERVER)
- LocalSystem
SQL Server Browser
- LocalSystem
SQL Server Agent (MSSQLSERVER)
- LocalSystem

So Sandisk makes this software called CMC. It's for controlling their enterprise USB drives. And their software won't install. It errors out saying that it couldn't drop the database on our SQL server (but it doesn't exist). If I make an empty DB by the same name, it sees it, and then errors out anyway. I am using the SA login for testing (I was using a purposed SQL account before) so I don't think it's a rights issue. Sandisk says it should work, and they suggested I use SQL server express. But we run VMs, and running SQL server in another VM is going to use more of our memory pool. Plus we want centralized backups and all that.

Do my service account logins have anything to do with it? Can someone tell me what these should be set to by default so I can change them back?

Here's a trace I did when I tried to install the software:

-- network protocol: TCP/IP
set quoted_identifier on
set arithabort off
set numeric_roundabort off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set cursor_close_on_commit off
set implicit_transactions off
set language us_english
set dateformat mdy
set datefirst 7
set transaction isolation level read committed

set implicit_transactions on
go
drop database [CruzerDb]
go
IF @@TRANCOUNT > 0 ROLLBACK TRAN
go

And here's more info if needed:

Product Version
- 9.00.3042.00
Edition
- Standard Edition
Server Collation
- SQL_Latin1_General_CP1_CI_AS
Is Clustered
- No
Is FullText Installed
- Yes
Is Integrated Security Only
- No
Is AWE Enabled
- No
# Processors (used by instance)
- 2

View 2 Replies View Related

How To Create A User Account For My Web Site In SQL Server Management Studio

Feb 18, 2008

Hi,
I keep getting a connection failed error message... CANNOT the DATABASE " " requested by the Login. The Login failed for User 'NT Authority/ Network Service' error and I figure I should create an account for the site to access the Database with but I do not know how to create an account in SQL server using the Management studio?? Anyone willing to give me the exact information I need to do this so I do not do something else and ruin things please??? I am not much of an SQL DBA. thanks in Advance.

View 10 Replies View Related

Xp_cmdshell - Service Account Permissions

Apr 22, 2008



Im having trouble getting xp_cmdshell to work after we changed the service account for our sql server. It was working perfectly before - so i know that execute permissions have been granted, and that we have a credential set up properly.

I have read that I need to ensure the service account has permissions to 'act as opertaing system' and 'replace a process level token'. I have granted these rights in the local security policy as well.

However, I still get :

A call to 'CreateProcessAsUser' failed with error code: '1314'.

Do I need to restart the service? Or the whole server? Or have I missed something else?

Any help will be much appreciated.

View 1 Replies View Related

What Permissions To Give Cluster Account In SQL

Sep 20, 2006

Hey guys. I'll have an active/active cluster and seperate accounts for SQL Services and Cluster service. The question is what rights should the cluster account have in SQL if I've removed the 'builtin admins' from SQL? Thank you



View 1 Replies View Related

SQL Server 7 Ignores User Permissions

Jul 20, 2005

I am having a problem restricting write access to tables in my database.In my database I have a table called, for the sake of argument, 'TableX'.In my SQL Server Logins, I have set up a login for 'Domain Users' using NTauthentication, and a login called 'FullTableX', using SQL Serverauthentication.I have added two users to my database relating to the above logins.I have added a role to my database called 'ReadTableX' with 'Domain Users'as a member of this role. 'ReadTableX' has SELECT permission only on arestricted set of tables.The only other role that 'Domain Users' is a member of is 'public', and'public' has no permissions on any of my tables.The user 'FullTableX' is a member of 'public', 'db_datareader' and'db_datawriter'With the above settings, I would expect user 'FullTableX' to have fullaccess (Select, Insert, Update and Delete) on all my database tables (so farso good), but any user connecting to the database with NT authentication(via ODBC System DSN) should only have read access to the limited set oftables. However, what is happening is that NT authenticated users also havefull access to all of the tables.What am I missing here??

View 3 Replies View Related

Setting Built-in Account To Local System

May 23, 2008

Hi folks.

When installing SQLServer 2005 Express, I use the following command line:

cmdline = " /qb ADDLOCAL=SQL_Engine,SQL_Data_Files SECURITYMODE=SQL INSTANCENAME=MyServer SAPWD=MyPwd DISABLENETWORKPROTOCOLS=0 SQLAUTOSTART=1 requiresmsiengine=1"

I noticed that when installing on a Windows XP machine, the installation results in a SQLServer instance which is configured with Built-in account = Network Service. However, with the same command line used on Windows 2000 machines, the configuration winds up being Built-in account = Local System. My understanding is that the default configuration is supposed to be Local System.

What can I do to ensure that the instance configuration is always Local System during the silent installation? This is required otherwise, under the Network Service configuration, it creates a messy situation to attach DBs.

Thanks!

Mike

View 1 Replies View Related

Setting Up Access For Network Service Account

Mar 6, 2007

I am trying to connect to a sql server from my asp.net application via windows authentication using the Network Service account. When I try to create a login for the ComputerNameNetwork Service account I get the following error.

I know I haven't mistyped it because I clicked the check names button and it showed as a valid id.

So what gives?

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Create failed for Login 'PREMIERDCNetwork Service'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Login&LinkId=20476

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

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

------------------------------

Windows NT user or group 'PREMIERDCNetwork Service' not found. Check the name again. (Microsoft SQL Server, Error: 15401)

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

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

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


View 5 Replies View Related

SQL Backup Agent Service Account Permissions

Dec 11, 2007



Hi,

If we were to assign permissions to a backup agent such as Backup Exec to backup the databases on the SQL server, what role would give the least amount but sufficient permissions to perform the backup? I know domain admin would make the agent a local admin and therefore allow it to back up the database but is there a role available to allow backup only?

Please note that I'm referring to a domain account used by Backup Exec to directly backup the databases rather than sql server agent.

Thanks.

View 2 Replies View Related

Registry Settings For Service Account Permissions

Jan 23, 2007

We are trying to configure registry settings to allow sql server service to run on a service account in SQL Server 2005. The registry has changed quite a bit from SQL 2000, and we are missing a setting in the software keys that causes sql server service not to start. If we apply permissions to all of HKEY_LOCAL_MACHINE/SOFTWARE, then the service starts, however company security policies do not allow this. Are there any specific keys we should look at, other than the obvious Microsoft/Microsoft SQL Server and Microsoft/MSSQL keys, in which we have already granted permissions to the service account?

Thanks,

Dave

View 1 Replies View Related

SQL Server 2008 :: Finding Permissions That A User Have

May 4, 2015

Is there anyway to find the permissions assigned to user. What level of access the user has in each db and the tables & is he able to see jobs. Each object and permissions

View 6 Replies View Related

Setting Service Account To LocalSystem Via Command Prompt

Dec 5, 2007



Hello,

I was wondering if there was any way to set the service account on sql server 2005 express to Local System via command prompt.

To giva some background to this issue, I am installing 2005 express via command prompt, however, the default service account is network I believe. However, when running this, I keep getting an "error 3415" whenever I try to attach a database, which states that the files are "read only", which they are not. However, when setting the service account to local or set the security mode to windows authenticaiton, I can attach just fine.

The parameters I use to install are pretty standard:


"/qb ADDLOCAL=ALL INSTANCENAME=<name>SAPWD=<pwrd> SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0 SQLAUTOSTART=1"

So I was wondering if there was some way to set the service account to local system to local using some command prompt parameter. OR if there was another way around the error 3415 that will enable me to attach a database, that I do not know about that I can use, preferrably via command prompt, but anything will be fine at this point.

Thank you all in advance.

View 6 Replies View Related

Sql Express Installation Problem Setting Sql Account To =NT AUTHORITYSYSTEM

Apr 4, 2006

Hello,

I am having trouble installing sql express from a command line on an XP o/s other than English, I know French and German have the problem I suspect this is caused by setting the sql account to ="NT AUTHORITYSYSTEM" my guess is that this is a localized string.

I get the following error

SQL Server Setup could not validate the service accounts. Either the service accounts have not been provided for all of the services being installed, or the specified username or password is incorrect. For each service, specify a valid username, password, and domain, or specify a built-in system account.

This is my command line

setup.exe" /QB REBOOT=REALLYSUPPRESS ADDLOCAL=ALL SQLBROWSERACCOUNT="NT AUTHORITYSYSTEM" SQLBROWSERPASSWORD= SQLACCOUNT="NT AUTHORITYSYSTEM" SQLPASSWORD= AGTACCOUNT="NT AUTHORITYSYSTEM" AGTACCOUNT= SECURITYMODE=SQL INSTANCENAME=KBMSS SAPWD=kbmsa DISABLENETWORKPROTOCOLS=0 SQLAUTOSTART=1 SCCCHECKLEVEL=IncompatibleComponents:1 ERRORREPORTING=2

Anyone else run into this?

Thanks,

Michael Gustafson

View 1 Replies View Related

Does Xp_cmdshell Proxy Account Need Admin-level Permissions?

Oct 4, 2007

Re: SQL Server 2005

Does the xp_cmdshell proxy account need admin-level permissions on the server?

The reason I ask this is because I keep getting "Access is Denied" errors when trying to run this command as a non-admin:

master..xp_cmdshell dtexec 'some package'

The 'some package' has an "execute process task" which calls a batch file on the server.

If the proxy account is NOT a local admin, the "execute process tasks" fails with an "Access is Denied" error.

If the proxy account is a local admin, it executes fine.

We have given "Everyone" FULL CONTROL of all the folders that are affected by the batch file, and it still does not work.

I am out of ideas at this point. It just does not work unless it's an admin.

Are we missing something here?


View 7 Replies View Related

Setting Permissions

Dec 27, 2005

we are using windows authentication. Is there a faster way to set permissions for each database than to go through each table and set them? Currently, to set the permissions from SQL Server Enterprise Manager, I click on Security > logins > select the properties for the IUSR account > Database Access > then check off each database that we allow access to. Next I go through each tables properties and set the permissions. Is there an easier, faster way to do this?

Miranda

View 2 Replies View Related

Setting Sql Server Authentication For Database User - Wont Let Me

May 22, 2006

I have created a database now I am setting login details for that user. I am using slq server authentication and entering a password of recommended length.

I enter my details in my webconfig file and I get -couldnot connect to database specified in connection string for sql data provider.

when I check the login properties the password has changed it appears to be the password for NT Authoritysystem, ie same length, what it is Idont know.

What am I missing?

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved