how can I open a .mdf aspnetDB DataBase ?

Hello everybody,

I am working with SqlExpress and MSSQL Server Management Studio Express and do not manage to open the aspnetDB .mdf database in which I am storing all data about my users.

I woulds like to open it and to be able to request it in order to check some strange things.

Actually, I'm experiencing an isssue with that database since the request just below gives me two results for only one user:

SELECT Member.Password, Member.PasswordAnswerFROM aspnet_MemberShip Member, aspnet_Users UsersWHERE Member.UserId=Users.UserIdAND Users.UserName='Admin'

Using this request returns me a user whom password is clear and an identical user whom password is hashed whereas I set PasswordFormat="Clear" in my Web.Config

Could you explain me how I may proceed please?

Thanx for your help

If you still have your project open, it could be that the project has a lock on the database file. Close your project in order to use MS SSMS express.

Otherwise, you can right-click the ASPNET.MDF database file and choose 'Open'. This will allow you to navigate the database using the Server Explorer tab, much like you would with SSMS.

Your problem lies in your SQL, however. UserId is the only Unique column in the default Users table because it is the primary key. This means that the UserName is NOT unique, and could be duplicated.

Use System.Web.Security.Membership.Provider to get a reference to the app's default membership provider, and use that to do what you need. (See the System.Web.Security.MembershipProvider class for available functions.)

|||

Thanx for your answer ps2goat,

I finally used VisualStudio Servers's Explorer to do so and was able to see all the information stored in the .mdf file.

This raises some questions about the issue I was dealing about above, but at the time, it is a solution for that precise problem ;)

In fact, I had two identical usernames in the database, one with a password saved in clear and the other hashed and, as you tell it, with a different unique ID.

I believe this comes from the fact that I used this .mdf file in more than 3 versions of the current prooject, making of it some kind of mess where it becomes to difficult to find what you're looking for.

Thanks for your help.

|||

You can just use visual studio directly to navigate through it. Also you can get that into sql express or any other db and reconstruct all the db.

how can I manage MSDE with SQL?

please I need some help about how can I get MSDE for VB6 and I want to know how to manage this on th Customer machineWhat do you mean by manage?|||Download MSDE from here:

http://www.microsoft.com/sql/msde/downloads/download.asp

Here is a web based administrative tool:

http://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en

If you want a Windows based administrative tool, you can use the SQL Server 2005 Express Manager to manage MSDE:

http://www.microsoft.com/downloads/details.aspx?familyid=C7A5CC62-EC54-4299-85FC-BA05C181ED55&displaylang=en

Before you can install the Express Manager, you must install SQL Server 2005 Express:

http://www.microsoft.com/downloads/details.aspx?familyid=1A722B0F-6CCA-4E8B-B6EA-12D9C450ED92&displaylang=en
sql

how can i manage database on lan base[network base]software

hi
my self avi
currently i am developing one application in vb 6 and back end as
sqlserver 7 which is used on lan.
i have some problem. like in my database i have one table salesvoucher
which has 'voucherno' field. when 2-3 user will work on salesform at a
time [since the softwrae will run on lan] then the same voucherno will
save for all users data which is wrong i need to save different voucherno
for each no. is there any way in sqlserver to apply some condition on
database or to set some its property[tables] so that at a time only one
users data will save depend on firstcome first serve base or is there any
way to make changes in programme.
plz help me regarding this i need it very badly.
since its my first lan based software plz give me some books name
regarding this software for vb6 and sqlserver7"avinash" <pawar_avinash@.rediffmail.com> wrote in message
news:00a8643e7e3050f1ff2f4ae6aa7209df@.localhost.ta lkaboutdatabases.com...
> hi
> my self avi
> currently i am developing one application in vb 6 and back end as
> sqlserver 7 which is used on lan.
> i have some problem. like in my database i have one table salesvoucher
> which has 'voucherno' field. when 2-3 user will work on salesform at a
> time [since the softwrae will run on lan] then the same voucherno will
> save for all users data which is wrong i need to save different voucherno
> for each no. is there any way in sqlserver to apply some condition on
> database or to set some its property[tables] so that at a time only one
> users data will save depend on firstcome first serve base or is there any
> way to make changes in programme.
> plz help me regarding this i need it very badly.
> since its my first lan based software plz give me some books name
> regarding this software for vb6 and sqlserver7

If the voucherno must be unique, then you should put a primary key or unique
constraint on that column, so that it's impossible to have duplicates. If
the voucherno is generated on the client, then you would have to handle the
error raised when a duplicate is inserted (such as error 2627 for primary
key violation), generate a new number, and submit it again.

Alternatively, you could generate the voucherno in the database. If you just
need an integer value, then you can use the IDENTITY property to generate
the number for you - see "IDENTITY (Property)" in Books Online. Every time
you insert a new row, MSSQL will generate a new number for you - this avoids
writing any code to generate new numbers.

Regarding books, you might find some useful information about SQL books
here:

http://vyaskn.tripod.com/sqlbooks.htm

Someone else may be able to suggest a good VB/SQL book, or you might want to
post in a VB group.

Simon|||Dear Avanish... sorry I cannot help you in dat... while I m just wanna
post a msg here... BYE

How can I import data from Excel to SQL server 2005 Express

I would like to import an Excel file into my SQL Server 2005 Express db. I'm using SQL Server Management Studio Express to manage my db.

I appreciate your suggestions,

You need to use SQL server Business Intelligence Development studio and create SSIS package

Using simple Drag and Drop controls

|||

Sorry, I do not have these tools to work with.

|||

Ok, Right click on the Database then Task -> Import

select your Data source as Microsoft Excel file map the fields to destination click finish

How can I get Enterprise Manager to see my remote server?

I need to manage a SQL Server installation over the internet via a VPN
connection.
Enterprise Manager can't see the server, when I put in the name, EM times
out.
How can I Register this server if EM can't see it from here?
If I Register the server while I'm at that site, should it then work from my
remote office?
Thanks
KelvinNot being able to connect to the SQL server in question may be due to a
couple of different issues.
Please try the below suggestions:
1 - Possibly due to latency in the VPN connection causing a connection
time-out.
- Increase the Enterprise Manager timeout for the connection
- In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
tab.
- Extend the value in the 'Login time-out' field (default of 10 seconds).
If the above doesn't work, then:
2 - Possibly a DNS/WINS resolution issue going over the VPN
- Run the Client Configuration Utility (CLICONFG.EXE) on your machine that
has the server registered in Enterprise Manager
- Click on the ALIAS tab
- Click ADD
- Type the name of the SQL Server (same name as you registered it with in
EM) in the 'Server Alias' field
- Click on the TCP/IP protocol (or applicable protocol if not using TCP/IP)
- In the 'Server Name' field, type the TCP/IP address for the server (or
the protocol's reference to the server if not using TCP/IP).
Dave
"Kelvin Beaton" wrote:
> I need to manage a SQL Server installation over the internet via a VPN
> connection.
>
> Enterprise Manager can't see the server, when I put in the name, EM times
> out.
>
> How can I Register this server if EM can't see it from here?
>
> If I Register the server while I'm at that site, should it then work from my
> remote office?
>
> Thanks
>
> Kelvin
>
>|||thanks Dave
The second option worked!
Thanks a million
Kelvin
"DBADave" <DBADave@.discussions.microsoft.com> wrote in message
news:F2C00FEF-4800-4DE3-BAEC-E0125CE8BB7A@.microsoft.com...
> Not being able to connect to the SQL server in question may be due to a
> couple of different issues.
> Please try the below suggestions:
> 1 - Possibly due to latency in the VPN connection causing a connection
> time-out.
> - Increase the Enterprise Manager timeout for the connection
> - In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
> tab.
> - Extend the value in the 'Login time-out' field (default of 10 seconds).
> If the above doesn't work, then:
> 2 - Possibly a DNS/WINS resolution issue going over the VPN
> - Run the Client Configuration Utility (CLICONFG.EXE) on your machine
> that
> has the server registered in Enterprise Manager
> - Click on the ALIAS tab
> - Click ADD
> - Type the name of the SQL Server (same name as you registered it with in
> EM) in the 'Server Alias' field
> - Click on the TCP/IP protocol (or applicable protocol if not using
> TCP/IP)
> - In the 'Server Name' field, type the TCP/IP address for the server (or
> the protocol's reference to the server if not using TCP/IP).
> Dave
>
> "Kelvin Beaton" wrote:
>> I need to manage a SQL Server installation over the internet via a VPN
>> connection.
>>
>> Enterprise Manager can't see the server, when I put in the name, EM times
>> out.
>>
>> How can I Register this server if EM can't see it from here?
>>
>> If I Register the server while I'm at that site, should it then work from
>> my
>> remote office?
>>
>> Thanks
>>
>> Kelvin
>>

How can I get Enterprise Manager to see my remote server?

I need to manage a SQL Server installation over the internet via a VPN
connection.
Enterprise Manager can't see the server, when I put in the name, EM times
out.
How can I Register this server if EM can't see it from here?
If I Register the server while I'm at that site, should it then work from my
remote office?
Thanks
Kelvin
Not being able to connect to the SQL server in question may be due to a
couple of different issues.
Please try the below suggestions:
1 - Possibly due to latency in the VPN connection causing a connection
time-out.
- Increase the Enterprise Manager timeout for the connection
- In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
tab.
- Extend the value in the 'Login time-out' field (default of 10 seconds).
If the above doesn't work, then:
2 - Possibly a DNS/WINS resolution issue going over the VPN
- Run the Client Configuration Utility (CLICONFG.EXE) on your machine that
has the server registered in Enterprise Manager
- Click on the ALIAS tab
- Click ADD
- Type the name of the SQL Server (same name as you registered it with in
EM) in the 'Server Alias' field
- Click on the TCP/IP protocol (or applicable protocol if not using TCP/IP)
- In the 'Server Name' field, type the TCP/IP address for the server (or
the protocol's reference to the server if not using TCP/IP).
Dave
"Kelvin Beaton" wrote:

> I need to manage a SQL Server installation over the internet via a VPN
> connection.
>
> Enterprise Manager can't see the server, when I put in the name, EM times
> out.
>
> How can I Register this server if EM can't see it from here?
>
> If I Register the server while I'm at that site, should it then work from my
> remote office?
>
> Thanks
>
> Kelvin
>
>
|||thanks Dave
The second option worked!
Thanks a million
Kelvin
"DBADave" <DBADave@.discussions.microsoft.com> wrote in message
news:F2C00FEF-4800-4DE3-BAEC-E0125CE8BB7A@.microsoft.com...[vbcol=seagreen]
> Not being able to connect to the SQL server in question may be due to a
> couple of different issues.
> Please try the below suggestions:
> 1 - Possibly due to latency in the VPN connection causing a connection
> time-out.
> - Increase the Enterprise Manager timeout for the connection
> - In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
> tab.
> - Extend the value in the 'Login time-out' field (default of 10 seconds).
> If the above doesn't work, then:
> 2 - Possibly a DNS/WINS resolution issue going over the VPN
> - Run the Client Configuration Utility (CLICONFG.EXE) on your machine
> that
> has the server registered in Enterprise Manager
> - Click on the ALIAS tab
> - Click ADD
> - Type the name of the SQL Server (same name as you registered it with in
> EM) in the 'Server Alias' field
> - Click on the TCP/IP protocol (or applicable protocol if not using
> TCP/IP)
> - In the 'Server Name' field, type the TCP/IP address for the server (or
> the protocol's reference to the server if not using TCP/IP).
> Dave
>
> "Kelvin Beaton" wrote:

How can I get Enterprise Manager to see my remote server?

I need to manage a SQL Server installation over the internet via a VPN
connection.
Enterprise Manager can't see the server, when I put in the name, EM times
out.
How can I Register this server if EM can't see it from here?
If I Register the server while I'm at that site, should it then work from my
remote office?
Thanks
Kelvin
Not being able to connect to the SQL server in question may be due to a
couple of different issues.
Please try the below suggestions:
1 - Possibly due to latency in the VPN connection causing a connection
time-out.
- Increase the Enterprise Manager timeout for the connection
- In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
tab.
- Extend the value in the 'Login time-out' field (default of 10 seconds).
If the above doesn't work, then:
2 - Possibly a DNS/WINS resolution issue going over the VPN
- Run the Client Configuration Utility (CLICONFG.EXE) on your machine that
has the server registered in Enterprise Manager
- Click on the ALIAS tab
- Click ADD
- Type the name of the SQL Server (same name as you registered it with in
EM) in the 'Server Alias' field
- Click on the TCP/IP protocol (or applicable protocol if not using TCP/IP)
- In the 'Server Name' field, type the TCP/IP address for the server (or
the protocol's reference to the server if not using TCP/IP).
Dave
"Kelvin Beaton" wrote:

> I need to manage a SQL Server installation over the internet via a VPN
> connection.
>
> Enterprise Manager can't see the server, when I put in the name, EM times
> out.
>
> How can I Register this server if EM can't see it from here?
>
> If I Register the server while I'm at that site, should it then work from my
> remote office?
>
> Thanks
>
> Kelvin
>
>
|||thanks Dave
The second option worked!
Thanks a million
Kelvin
"DBADave" <DBADave@.discussions.microsoft.com> wrote in message
news:F2C00FEF-4800-4DE3-BAEC-E0125CE8BB7A@.microsoft.com...[vbcol=seagreen]
> Not being able to connect to the SQL server in question may be due to a
> couple of different issues.
> Please try the below suggestions:
> 1 - Possibly due to latency in the VPN connection causing a connection
> time-out.
> - Increase the Enterprise Manager timeout for the connection
> - In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
> tab.
> - Extend the value in the 'Login time-out' field (default of 10 seconds).
> If the above doesn't work, then:
> 2 - Possibly a DNS/WINS resolution issue going over the VPN
> - Run the Client Configuration Utility (CLICONFG.EXE) on your machine
> that
> has the server registered in Enterprise Manager
> - Click on the ALIAS tab
> - Click ADD
> - Type the name of the SQL Server (same name as you registered it with in
> EM) in the 'Server Alias' field
> - Click on the TCP/IP protocol (or applicable protocol if not using
> TCP/IP)
> - In the 'Server Name' field, type the TCP/IP address for the server (or
> the protocol's reference to the server if not using TCP/IP).
> Dave
>
> "Kelvin Beaton" wrote:

How can I get Enterprise Manager to see my remote server?

I need to manage a SQL Server installation over the internet via a VPN
connection.
Enterprise Manager can't see the server, when I put in the name, EM times
out.
How can I Register this server if EM can't see it from here?
If I Register the server while I'm at that site, should it then work from my
remote office?
Thanks
KelvinNot being able to connect to the SQL server in question may be due to a
couple of different issues.
Please try the below suggestions:
1 - Possibly due to latency in the VPN connection causing a connection
time-out.
- Increase the Enterprise Manager timeout for the connection
- In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
tab.
- Extend the value in the 'Login time-out' field (default of 10 seconds).
If the above doesn't work, then:
2 - Possibly a DNS/WINS resolution issue going over the VPN
- Run the Client Configuration Utility (CLICONFG.EXE) on your machine that
has the server registered in Enterprise Manager
- Click on the ALIAS tab
- Click ADD
- Type the name of the SQL Server (same name as you registered it with in
EM) in the 'Server Alias' field
- Click on the TCP/IP protocol (or applicable protocol if not using TCP/IP)
- In the 'Server Name' field, type the TCP/IP address for the server (or
the protocol's reference to the server if not using TCP/IP).
Dave
"Kelvin Beaton" wrote:

> I need to manage a SQL Server installation over the internet via a VPN
> connection.
>
> Enterprise Manager can't see the server, when I put in the name, EM times
> out.
>
> How can I Register this server if EM can't see it from here?
>
> If I Register the server while I'm at that site, should it then work from
my
> remote office?
>
> Thanks
>
> Kelvin
>
>|||thanks Dave
The second option worked!
Thanks a million
Kelvin
"DBADave" <DBADave@.discussions.microsoft.com> wrote in message
news:F2C00FEF-4800-4DE3-BAEC-E0125CE8BB7A@.microsoft.com...[vbcol=seagreen]
> Not being able to connect to the SQL server in question may be due to a
> couple of different issues.
> Please try the below suggestions:
> 1 - Possibly due to latency in the VPN connection causing a connection
> time-out.
> - Increase the Enterprise Manager timeout for the connection
> - In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
> tab.
> - Extend the value in the 'Login time-out' field (default of 10 seconds).
> If the above doesn't work, then:
> 2 - Possibly a DNS/WINS resolution issue going over the VPN
> - Run the Client Configuration Utility (CLICONFG.EXE) on your machine
> that
> has the server registered in Enterprise Manager
> - Click on the ALIAS tab
> - Click ADD
> - Type the name of the SQL Server (same name as you registered it with in
> EM) in the 'Server Alias' field
> - Click on the TCP/IP protocol (or applicable protocol if not using
> TCP/IP)
> - In the 'Server Name' field, type the TCP/IP address for the server (or
> the protocol's reference to the server if not using TCP/IP).
> Dave
>
> "Kelvin Beaton" wrote:
>