Can not access SQL database for Website security settings

I'm using Visual Studio 2005 (8.0.50727.42) and going into the menu option Website > ASP.Net Configuration, access the security tab and all I get is an error message stating that there is a problem with the selected data store "Unable to Connect to the SQL Server Database"

I have SQL Server 2005 (Express Edition). I have created a database "NetDev" with the right connection, etc.

I can use the SQL server fine for my Windows applications, but somehow this ASp.Net Configuration tool is not making any sense.

I also used the aspnet_regsql command from framework 2.0 to create a DataBase to no avail.

Does anyone out there knows if there is a bug with this tool?

Responding to my own question.

I finally reinstalled everything from scratch, IIS first, and then Visual Studio and my problem went away. It obviously had some corruption as I havce deleted and recreated many apps I may have induced some problems. Also the NET Service had to be added to the APP-Data dir with write permissions (this may have been the real cause).

sql

Can MSSQL load a tab delimited text file?

Hi all...

I would like to know if SQL SERVER can load a tab delimited text file.

If yes, how?

A search on the web did not return me the "load data" command as mysql
or other.

Thank you all.BULK INSERT|||Oh my god...

Why you say it is a bulk insert man?? Come on...

I am a MySQL user and wants to know if i can load my data on MSSQL
without a need of a converter.|||<joealey2003@.yahoo.com> wrote in message
news:1117271736.412801.299580@.f14g2000cwb.googlegr oups.com...
> Oh my god...
> Why you say it is a bulk insert man?? Come on...
> I am a MySQL user and wants to know if i can load my data on MSSQL
> without a need of a converter.

I'm not sure what you don't like about his answer. Did you even bother to
look up the command he gave you?
|||Don't you have Books Online available? I expect Q. John Chen assumed you
would lookup the command:
http://msdn.microsoft.com/library/d...asp?frame=true

--
David Portas
SQL Server MVP
--

<joealey2003@.yahoo.com> wrote in message
news:1117271736.412801.299580@.f14g2000cwb.googlegr oups.com...
> Oh my god...
> Why you say it is a bulk insert man?? Come on...
> I am a MySQL user and wants to know if i can load my data on MSSQL
> without a need of a converter.|||Oh...

So Bulk Insert is the command...

Thank you all...

can i use scm to change to sa password

for some reason i changed my sqlserver sa password as 'newpassword', i try to find a way to resolve the sqlserveragent settings , in connection tab, i choose 'sqlserver authority',
i try the command below to changed the sa pwd:

>scm -Action 7 -Service sqlserveragent -Pwd newpassword
>net start sqlserveragent
but the modify of scm is not commit although the message tell me that modify is successful.
can I use SCM to modify sqlserveragent settings?

Hi,

to change the SQL Server Agent password , first you have to change the password for a User which is used to start SQL Server Agent service and then go to Start->Settings->Control Panel->Administrative Tools-> Services->Select services ->Open it->go to Log On->and then change your new password here too.

Hemantgiri S. Goswami

|||

We can use windows authority to start mssqlserveragent and log the sqlserver instance,and windows authority+sql authority also,

windows authority to start sqlserveragent service, sql authority or windows authority to log the sqlserver instance and run service

i use sql authority to log the sqlserver instance(setting in connection option),after change the sa password,i want to use code to change the sqlserveragent settings,such as connection login user (sa) password.Can I do it?

|||

How possible is it to have this done through t-sql statements? I would like to do this with sql scripts and not using Enterprise manager to change the sql server agent's connection parameters (username and password)

Someone shed some light on this.

Cheers

|||i do not use T-SQL,but SQLSERVER tools named SCM,you can find this file in the installed directory|||

I will not recommand for T-SQL

Thanks

Faiz Farazi

www.databasetimes.net

Best learning center for Microsoft

http://www.lascomp.com

|||But, is there a way to do it through t-sql was my question. If so how to do that?|||

Yes you can use SP_PASSWORD statement and BOL defines that:

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use ALTER LOGIN instead.

|||

Please read my question again. I think it was misread. I didn't want to know how to change the password... I wanted to know using t-sql how to change the connection parameters for SQL server Agent (username and password) that shows up on SQL server Agent Properties >> connection Tab >> that uses a local system account... which in this case I wanted to change it to use SA and its password or any other that has got proper permissions. Hope this explains.

|||

Hi,

Any success with your query? Have a similar requirement and have been looking around for an answer. No success yet :-(

can i use scm to change to sa password

for some reason i changed my sqlserver sa password as 'newpassword', i try to find a way to resolve the sqlserveragent settings , in connection tab, i choose 'sqlserver authority',
i try the command below to changed the sa pwd:

>scm -Action 7 -Service sqlserveragent -Pwd newpassword
>net start sqlserveragent
but the modify of scm is not commit although the message tell me that modify is successful.
can I use SCM to modify sqlserveragent settings?

Hi,

to change the SQL Server Agent password , first you have to change the password for a User which is used to start SQL Server Agent service and then go to Start->Settings->Control Panel->Administrative Tools-> Services->Select services ->Open it->go to Log On->and then change your new password here too.

Hemantgiri S. Goswami

|||

We can use windows authority to start mssqlserveragent and log the sqlserver instance,and windows authority+sql authority also,

windows authority to start sqlserveragent service, sql authority or windows authority to log the sqlserver instance and run service

i use sql authority to log the sqlserver instance(setting in connection option),after change the sa password,i want to use code to change the sqlserveragent settings,such as connection login user (sa) password.Can I do it?

|||

How possible is it to have this done through t-sql statements? I would like to do this with sql scripts and not using Enterprise manager to change the sql server agent's connection parameters (username and password)

Someone shed some light on this.

Cheers

|||i do not use T-SQL,but SQLSERVER tools named SCM,you can find this file in the installed directory|||

I will not recommand for T-SQL

Thanks

Faiz Farazi

www.databasetimes.net

Best learning center for Microsoft

http://www.lascomp.com

|||But, is there a way to do it through t-sql was my question. If so how to do that?|||

Yes you can use SP_PASSWORD statement and BOL defines that:

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use ALTER LOGIN instead.

|||

Please read my question again. I think it was misread. I didn't want to know how to change the password... I wanted to know using t-sql how to change the connection parameters for SQL server Agent (username and password) that shows up on SQL server Agent Properties >> connection Tab >> that uses a local system account... which in this case I wanted to change it to use SA and its password or any other that has got proper permissions. Hope this explains.

|||

Hi,

Any success with your query? Have a similar requirement and have been looking around for an answer. No success yet :-(

can i use scm to change to sa password

for some reason i changed my sqlserver sa password as 'newpassword', i try to find a way to resolve the sqlserveragent settings , in connection tab, i choose 'sqlserver authority',
i try the command below to changed the sa pwd:

>scm -Action 7 -Service sqlserveragent -Pwd newpassword
>net start sqlserveragent
but the modify of scm is not commit although the message tell me that modify is successful.
can I use SCM to modify sqlserveragent settings?

Hi,

to change the SQL Server Agent password , first you have to change the password for a User which is used to start SQL Server Agent service and then go to Start->Settings->Control Panel->Administrative Tools-> Services->Select services ->Open it->go to Log On->and then change your new password here too.

Hemantgiri S. Goswami

|||

We can use windows authority to start mssqlserveragent and log the sqlserver instance,and windows authority+sql authority also,

windows authority to start sqlserveragent service, sql authority or windows authority to log the sqlserver instance and run service

i use sql authority to log the sqlserver instance(setting in connection option),after change the sa password,i want to use code to change the sqlserveragent settings,such as connection login user (sa) password.Can I do it?

|||

How possible is it to have this done through t-sql statements? I would like to do this with sql scripts and not using Enterprise manager to change the sql server agent's connection parameters (username and password)

Someone shed some light on this.

Cheers

|||i do not use T-SQL,but SQLSERVER tools named SCM,you can find this file in the installed directory
|||

I will not recommand for T-SQL

Thanks

Faiz Farazi

www.databasetimes.net

Best learning center for Microsoft

http://www.lascomp.com

|||But, is there a way to do it through t-sql was my question. If so how to do that?|||

Yes you can use SP_PASSWORD statement and BOL defines that:

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use ALTER LOGIN instead.

|||

Please read my question again. I think it was misread. I didn't want to know how to change the password... I wanted to know using t-sql how to change the connection parameters for SQL server Agent (username and password) that shows up on SQL server Agent Properties >> connection Tab >> that uses a local system account... which in this case I wanted to change it to use SA and its password or any other that has got proper permissions. Hope this explains.

|||

Hi,

Any success with your query? Have a similar requirement and have been looking around for an answer. No success yet :-(

can i use scm to change to sa password

for some reason i changed my sqlserver sa password as 'newpassword', i try to find a way to resolve the sqlserveragent settings , in connection tab, i choose 'sqlserver authority',
i try the command below to changed the sa pwd:

>scm -Action 7 -Service sqlserveragent -Pwd newpassword
>net start sqlserveragent
but the modify of scm is not commit although the message tell me that modify is successful.
can I use SCM to modify sqlserveragent settings?

Hi,

to change the SQL Server Agent password , first you have to change the password for a User which is used to start SQL Server Agent service and then go to Start->Settings->Control Panel->Administrative Tools-> Services->Select services ->Open it->go to Log On->and then change your new password here too.

Hemantgiri S. Goswami

|||

We can use windows authority to start mssqlserveragent and log the sqlserver instance,and windows authority+sql authority also,

windows authority to start sqlserveragent service, sql authority or windows authority to log the sqlserver instance and run service

i use sql authority to log the sqlserver instance(setting in connection option),after change the sa password,i want to use code to change the sqlserveragent settings,such as connection login user (sa) password.Can I do it?

|||

How possible is it to have this done through t-sql statements? I would like to do this with sql scripts and not using Enterprise manager to change the sql server agent's connection parameters (username and password)

Someone shed some light on this.

Cheers

|||i do not use T-SQL,but SQLSERVER tools named SCM,you can find this file in the installed directory
|||

I will not recommand for T-SQL

Thanks

Faiz Farazi

www.databasetimes.net

Best learning center for Microsoft

http://www.lascomp.com

|||But, is there a way to do it through t-sql was my question. If so how to do that?|||

Yes you can use SP_PASSWORD statement and BOL defines that:

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use ALTER LOGIN instead.

|||

Please read my question again. I think it was misread. I didn't want to know how to change the password... I wanted to know using t-sql how to change the connection parameters for SQL server Agent (username and password) that shows up on SQL server Agent Properties >> connection Tab >> that uses a local system account... which in this case I wanted to change it to use SA and its password or any other that has got proper permissions. Hope this explains.

|||

Hi,

Any success with your query? Have a similar requirement and have been looking around for an answer. No success yet :-(