Click here to Skip to main content
15,914,419 members
Home / Discussions / Web Development
   

Web Development

 
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 
QuestionDynamically Create a WebService Pin
BenClark20-Jul-09 6:03
BenClark20-Jul-09 6:03 
AnswerRe: Dynamically Create a WebService Pin
Robin_Roy22-Jul-09 16:31
Robin_Roy22-Jul-09 16:31 
QuestionAccordian control in AJAX Pin
Lonnie R Thomas20-Jul-09 6:02
Lonnie R Thomas20-Jul-09 6:02 
AnswerRe: Accordian control in AJAX Pin
jinaka21-Jul-09 17:51
jinaka21-Jul-09 17:51 
GeneralRe: Accordian control in AJAX Pin
Lonnie R Thomas23-Jul-09 3:00
Lonnie R Thomas23-Jul-09 3:00 
QuestionHow to write in php Pin
udch19-Jul-09 0:06
udch19-Jul-09 0:06 
AnswerRe: How to write in php Pin
Marc Firth19-Jul-09 22:46
Marc Firth19-Jul-09 22:46 
AnswerRe: How to write in php Pin
Marc Firth19-Jul-09 22:47
Marc Firth19-Jul-09 22:47 

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.