Click here to Skip to main content
15,921,113 members
Home / Discussions / Web Development
   

Web Development

 
GeneralRe: Getting Message : can not open database "Name" requested by the login. The login failed. Login failed for user 'XP\IUser. Pin
SeMartens23-Jul-09 2:01
SeMartens23-Jul-09 2:01 
QuestionFree websites templates Pin
sheemap21-Jul-09 21:59
sheemap21-Jul-09 21:59 
AnswerRe: Free websites templates Pin
Vasudevan Deepak Kumar22-Jul-09 3:11
Vasudevan Deepak Kumar22-Jul-09 3:11 
QuestionReal Time Data For Indian Stocks Pin
chakram32121-Jul-09 19:24
chakram32121-Jul-09 19:24 
AnswerRe: Real Time Data For Indian Stocks Pin
Ashfield21-Jul-09 21:23
Ashfield21-Jul-09 21:23 
AnswerRe: Real Time Data For Indian Stocks Pin
Nagy Vilmos22-Jul-09 1:49
professionalNagy Vilmos22-Jul-09 1:49 
QuestionIn IE8 (XP), JS behaves differently if my account has Administrator access??? Pin
Jane Williams21-Jul-09 5:44
Jane Williams21-Jul-09 5:44 
AnswerRe: In IE8 (XP), JS behaves differently if my account has Administrator access??? Pin
DoctorMick21-Jul-09 6:21
DoctorMick21-Jul-09 6:21 
GeneralRe: In IE8 (XP), JS behaves differently if my account has Administrator access??? Pin
Jane Williams21-Jul-09 6:23
Jane Williams21-Jul-09 6:23 
GeneralRe: In IE8 (XP), JS behaves differently if my account has Administrator access??? Pin
Vasudevan Deepak Kumar22-Jul-09 3:14
Vasudevan Deepak Kumar22-Jul-09 3:14 
GeneralRe: In IE8 (XP), JS behaves differently if my account has Administrator access??? Pin
Jane Williams22-Jul-09 3:15
Jane Williams22-Jul-09 3:15 
QuestionCan not connect to sql server database from web application(Configured in IIS) --- Pin
Hemant Thaker20-Jul-09 22:12
Hemant Thaker20-Jul-09 22:12 
AnswerRe: Can not connect to sql server database from web application(Configured in IIS) --- Pin
DoctorMick21-Jul-09 0:15
DoctorMick21-Jul-09 0:15 
QuestionRe: Can not connect to sql server database from web application(Configured in IIS) --- Pin
Hemant Thaker22-Jul-09 0:39
Hemant Thaker22-Jul-09 0:39 
AnswerRe: Can not connect to sql server database from web application(Configured in IIS) --- Pin
Paddy Boyd21-Jul-09 0:25
Paddy Boyd21-Jul-09 0:25 
QuestionRe: Can not connect to sql server database from web application(Configured in IIS) ----- Pin
Hemant Thaker22-Jul-09 0:41
Hemant Thaker22-Jul-09 0:41 
AnswerRe: Can not connect to sql server database from web application(Configured in IIS) --- Pin
Abhishek Sur21-Jul-09 3:02
professionalAbhishek Sur21-Jul-09 3:02 
QuestionRe: Can not connect to sql server database from web application(Configured in IIS) --- Pin
Hemant Thaker22-Jul-09 0:38
Hemant Thaker22-Jul-09 0:38 
GeneralFinally I got the solution Pin
Hemant Thaker23-Jul-09 21:55
Hemant Thaker23-Jul-09 21:55 
Hi...

As u said, was right but was not getting my way out creating users and logins.I did search something and its like as follows

Enabling SQL Authentication

STEP1:
You need to enable SQL Authentication on the machine. This is complex in SQLExpress and you need to edit the registry. Copy the following lines of text onto a Notepad and save it with extention .REG.
-------------COPY BELOW---------------------------------
Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer]
"LoginMode"=dword:00000002
-------------COPY TILL THIS---------------------------------
STEP2: Double Click on the .REG file to change the registry. This change the Authentication Mode to enable SQL Authentication.

STEP3: Restart the SQL Server Express Service or reboot the machine for registry change to take effect.

Next, you need to add a user with SQLLogin. To do this: Login to SQLExpress using Express Manager and run the script below:
-------------------------------------------
USE MASTER
sp_addLogin 'aspuser', 'aspuser@123'
GO
sp_addsrvrolemember 'aspuser', 'sysadmin'
GO
USE Cartridge
EXEC sp_adduser 'aspuser'
-------------------------------------------

In case you want to reduce the privilege for the user then you can specify something other than sysadmin, but we can think of that once this works.

Now change your connection string as follows:
connectionString = "server=.\\SQLExpress;uid=aspuser;pwd=aspuser@123;database=cartridge;";

////////////////////////////////////////
U may need to change connectionstring probably remove one '\' from server name

May be this can help someone...

thanks for ur support
Hemant

By:
Hemant Thaker

Questioncall serverside functions from javascript Pin
220820-Jul-09 21:52
220820-Jul-09 21:52 
AnswerRe: call serverside functions from javascript Pin
Marc Firth21-Jul-09 0:01
Marc Firth21-Jul-09 0:01 
AnswerRe: call serverside functions from javascript Pin
dan!sh 21-Jul-09 18:08
professional dan!sh 21-Jul-09 18:08 
Questionchange asp gridview mode using javascript Pin
220820-Jul-09 21:50
220820-Jul-09 21:50 
AnswerRe: change asp gridview mode using javascript Pin
Abhishek Sur21-Jul-09 3:05
professionalAbhishek Sur21-Jul-09 3:05 
QuestionCan I view all crystal report pages as serial ? Pin
kindman_nb20-Jul-09 10:42
kindman_nb20-Jul-09 10:42 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.