No ldf file but have mdf file

Hi there,

I am using Sql Server Express and have an mdf file I want to attach but I don't have the ldf file. Any suggestions?

Thanks,

Eric

Hi Eric,

To add an existing database .mdf file to SQL Server, you can use Attach. Here are the steps.

1. Copy the .mdf file and.ldf (if exists) to another folder.

2. Right click on Databases, and select Attach from the popup menu.

3. In the Attach Databases dialog box, click Add button and select the .mdf file.

4. Click OK to finish, and the database will be attached to your database list in Management Studio.

Thanks.

|||

ThanksNai-Dong.

But I get the following message below when clicking OK. I think there are two problems. One is I have Express edition and the database has a Job script (and Express doesn't have Sql Server Agent), two the database did not close properly. I will try to find another database version. However thank you for your help.

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

Attach database failed for Server 'INDIVIDU-B3MSFN\SQLEXPRESS'. (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=Attach+database+Server&LinkId=20476

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

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

----------

Could not open new database 'LittleItalyVineyard'. CREATE DATABASE is aborted.
File activation failure. The physical file name "C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\LittleItalyVineyard_log.ldf" may be incorrect.
The log cannot be rebuilt because the database was not cleanly shut down. (Microsoft SQL Server, Error: 1813)

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

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

OK
----------

|||

Hi Eric,

Just as you said, you'd better to find another database management version and retry the steps above.

Good Luck!

No indication of the SQL Server edition in the About window

I installed the SQL Server 2005 standard edition after uninstalling the Express edition.

When i look in the 'About' screen in the 'SQL Server Managment studio', i don't see indication that the SQL Server 2005 i currently work with is the Standard Edition. There are only categories and their numbers of versions.

How do i know that the Edition i work on ,now , is the Standard edition ?

Open up Management Studio and run "select @.@.version". This will tell you your SQL and OS details, including edition.

Thanks,
Sam Lester (MSFT)

|||Thanks , works like a charm.

No Import/Export Option in Mgmt Studio Express

Hi,

I just installed SQL Server 2005 Express. I would like to import tables from

another DB, and I read in the help files that I just need to (1) right-click on

a non-system database in Management Studio Express, and (2) select Import/Export

under the Tasks menu.

I tried this, but my Tasks menu only contains these options: Detach, Shrink,

Backup, Restore, Generate Scripts.

I googled for \"sql server 2005 "no import" tasks\", and it appears that a

couple of people have had this problem -- the only solution I read was to

install the "Workstation Components," but I already have, and still no luck.

Any idea what I need to do? Thanks!

Did you try right clicking on the database in the object explorer window. Try that, and then the All Tasks, Generate SQL Scripts option.|||Okay, I right-clicked on my database in the object explorer, then went to Tasks->Generate Scripts. This database is empty, though (I want to import a SQL Server 7 DB into it), so I end up getting a message that says "There are no objects in database of the types scriptable by this wizard."

Ultimately, I just need to import a SQL Server 7 database into SQL Server 2005 Express, but I can't find an "import" option in 2005. Is there some component I need to install?|||Ah, I think I need SQL Server Integration Services (SSIS), and that is apparently not included in SQL Server 2005 Express Edition (see "Unsupported Features" in http://msdn2.microsoft.com/en-us/library/ms365166.aspx). Mystery solved.

No full-text supported languages found in SQL Server Express with Advanced Services

I've downloaded SQL Server Express with Advanced Services from http://msdn.microsoft.com/vstudio/express/sql/download/ and installed all components. When I try to create a full-text catalog, I get the following message:

No full-text supported languages found.

select * from sys.fulltext_languages
returns no lines.

How

can neutral, English or maybe Hungarian word breakers be installed?

Thanks

Hello Peter

Are you sure you installed Full Text Support option when installing SQL Express?

Thanks,

|||

I have just installed SQL 2005 Express with Advanced Services to test this out and it returns me all the languages fine :

lcid name

-- --

2052 Simplified Chinese

1028 Traditional Chinese

1031 German

2057 British English

1033 English

3082 Spanish

1036 French

1040 Italian

1041 Japanese

1042 Korean

0 Neutral

1043 Dutch

1053 Swedish

1054 Thai

3076 Chinese (Hong Kong SAR, PRC)

5124 Chinese (Macau SAR)

4100 Chinese (Singapore)

(17 row(s) affected)

Just make sure you have install Full Text Search option.

|||It was surely installed because msftesql.exe was running.

I reinstalled Sql Server Express with the following changes and now full-text search works:
- I use default instance instead of named instance
- IIS was enabled during installation
- The installation folder was selected so that to be different from the folder of previous installations.

Maybe the Sql Server 2005 wasn't removed correctly before installing Express and some components had conflict with each other. I don't know what the real reason was of the problem. The important thing is that now it works.|||

Hi,

I Have the same problem, i execute the T-sql statement select * from sys.fulltext_languages and i get zero rows, i uninstalled and installed again and nothing happend i still have zero when executing that statement, i try another computer and there evrything went fine!.. i do have Microsoft Net framework, and everything but i still can get this to work! help please!!!

|||Hello everybody, I am facing the same issue. It's really frustrating.
I have removed and reinstalled SQL Express 3 times, changed the installation path, but no hope.
I can't set it as the default instance since I'm using MSDE as default instance.
Any idea please?|||

Are you sure you actually installed FTS; this feature is not installed by default, you must specifically select it from the feature list. Open up the SQL Configuration Manager and look at the Services node to verify that SQL Server FullText Search is listed and running.

If it's not listed, you didn't install it and you'll need to go into maintenance mode and select it from the feature list to get it installed.

Mike

|||

Hi,

I am having a similar problem. How do I go to maintenance mode? I also can't find anything called "SQL Configuration Manager".

cheers,

Bernie

|||

Hello Mike and thanks for the reply.
Of course I have installed FTS and it's listed in the configuration manager.
This problem is driving me crazy, it has taken 3 days from the tight timeframe of my project and I didn't find any solution.
I have removed MSDE, removed everything related to MsSql from the registry, deleted the installation directory, used "Windows install clean up" and reinstalled SQL Express with FTS as default instance may be more than 5 times and no hope.
Is there any way to install these damn languages manually? in the registry or whatever.
May be the problem is that SQL Express (without Advanced services) was installed previously and some trace is kept in the registry.
I don't know!
Any idea is really appreciated.

No full-text supported languages found in SQL Server Express with Advanced Services

I've downloaded SQL Server Express with Advanced Services from http://msdn.microsoft.com/vstudio/express/sql/download/ and installed all components. When I try to create a full-text catalog, I get the following message:

No full-text supported languages found.

select * from sys.fulltext_languages
returns no lines.

How can neutral, English or maybe Hungarian word breakers be installed?

Thanks

Hello Peter

Are you sure you installed Full Text Support option when installing SQL Express?

Thanks,

|||

I have just installed SQL 2005 Express with Advanced Services to test this out and it returns me all the languages fine :

lcid name

-- --

2052 Simplified Chinese

1028 Traditional Chinese

1031 German

2057 British English

1033 English

3082 Spanish

1036 French

1040 Italian

1041 Japanese

1042 Korean

0 Neutral

1043 Dutch

1053 Swedish

1054 Thai

3076 Chinese (Hong Kong SAR, PRC)

5124 Chinese (Macau SAR)

4100 Chinese (Singapore)

(17 row(s) affected)

Just make sure you have install Full Text Search option.

|||It was surely installed because msftesql.exe was running.

I reinstalled Sql Server Express with the following changes and now full-text search works:
- I use default instance instead of named instance
- IIS was enabled during installation
- The installation folder was selected so that to be different from the folder of previous installations.

Maybe the Sql Server 2005 wasn't removed correctly before installing Express and some components had conflict with each other. I don't know what the real reason was of the problem. The important thing is that now it works.
|||

Hi,

I Have the same problem, i execute the T-sql statement select*fromsys.fulltext_languages and i get zero rows, i uninstalled and installed again and nothing happend i still have zero when executing that statement, i try another computer and there evrything went fine!.. i do have Microsoft Net framework, and everything but i still can get this to work! help please!!!

|||Hello everybody, I am facing the same issue. It's really frustrating.
I have removed and reinstalled SQL Express 3 times, changed the installation path, but no hope.
I can't set it as the default instance since I'm using MSDE as default instance.
Any idea please?
|||

Are you sure you actually installed FTS; this feature is not installed by default, you must specifically select it from the feature list. Open up the SQL Configuration Manager and look at the Services node to verify that SQL Server FullText Search is listed and running.

If it's not listed, you didn't install it and you'll need to go into maintenance mode and select it from the feature list to get it installed.

Mike

|||

Hi,

I am having a similar problem. How do I go to maintenance mode? I also can't find anything called "SQL Configuration Manager".

cheers,

Bernie

|||

Hello Mike and thanks for the reply.
Of course I have installed FTS and it's listed in the configuration manager.
This problem is driving me crazy, it has taken 3 days from the tight timeframe of my project and I didn't find any solution.
I have removed MSDE, removed everything related to MsSql from the registry, deleted the installation directory, used "Windows install clean up" and reinstalled SQL Express with FTS as default instance may be more than 5 times and no hope.
Is there any way to install these damn languages manually? in the registry or whatever.
May be the problem is that SQL Express (without Advanced services) was installed previously and some trace is kept in the registry.
I don't know!
Any idea is really appreciated.

No full-text supported languages found in SQL Server Express with Advanced Services

I've downloaded SQL Server Express with Advanced Services from http://msdn.microsoft.com/vstudio/express/sql/download/ and installed all components. When I try to create a full-text catalog, I get the following message:

No full-text supported languages found.

select * from sys.fulltext_languages
returns no lines.

How

can neutral, English or maybe Hungarian word breakers be installed?

Thanks

Hello Peter

Are you sure you installed Full Text Support option when installing SQL Express?

Thanks,

|||

I have just installed SQL 2005 Express with Advanced Services to test this out and it returns me all the languages fine :

lcid name

-- --

2052 Simplified Chinese

1028 Traditional Chinese

1031 German

2057 British English

1033 English

3082 Spanish

1036 French

1040 Italian

1041 Japanese

1042 Korean

0 Neutral

1043 Dutch

1053 Swedish

1054 Thai

3076 Chinese (Hong Kong SAR, PRC)

5124 Chinese (Macau SAR)

4100 Chinese (Singapore)

(17 row(s) affected)

Just make sure you have install Full Text Search option.

|||It was surely installed because msftesql.exe was running.

I reinstalled Sql Server Express with the following changes and now full-text search works:
- I use default instance instead of named instance
- IIS was enabled during installation
- The installation folder was selected so that to be different from the folder of previous installations.

Maybe the Sql Server 2005 wasn't removed correctly before installing Express and some components had conflict with each other. I don't know what the real reason was of the problem. The important thing is that now it works.|||

Hi,

I Have the same problem, i execute the T-sql statement select * from sys.fulltext_languages and i get zero rows, i uninstalled and installed again and nothing happend i still have zero when executing that statement, i try another computer and there evrything went fine!.. i do have Microsoft Net framework, and everything but i still can get this to work! help please!!!

|||Hello everybody, I am facing the same issue. It's really frustrating.
I have removed and reinstalled SQL Express 3 times, changed the installation path, but no hope.
I can't set it as the default instance since I'm using MSDE as default instance.
Any idea please?|||

Are you sure you actually installed FTS; this feature is not installed by default, you must specifically select it from the feature list. Open up the SQL Configuration Manager and look at the Services node to verify that SQL Server FullText Search is listed and running.

If it's not listed, you didn't install it and you'll need to go into maintenance mode and select it from the feature list to get it installed.

Mike

|||

Hi,

I am having a similar problem. How do I go to maintenance mode? I also can't find anything called "SQL Configuration Manager".

cheers,

Bernie

|||

Hello Mike and thanks for the reply.
Of course I have installed FTS and it's listed in the configuration manager.
This problem is driving me crazy, it has taken 3 days from the tight timeframe of my project and I didn't find any solution.
I have removed MSDE, removed everything related to MsSql from the registry, deleted the installation directory, used "Windows install clean up" and reinstalled SQL Express with FTS as default instance may be more than 5 times and no hope.
Is there any way to install these damn languages manually? in the registry or whatever.
May be the problem is that SQL Express (without Advanced services) was installed previously and some trace is kept in the registry.
I don't know!
Any idea is really appreciated.

No full-text supported languages found in SQL Server Express with Advanced Services

I've downloaded SQL Server Express with Advanced Services from http://msdn.microsoft.com/vstudio/express/sql/download/ and installed all components. When I try to create a full-text catalog, I get the following message:

No full-text supported languages found.

select * from sys.fulltext_languages
returns no lines.

How can neutral, English or maybe Hungarian word breakers be installed?

Thanks

Hello Peter

Are you sure you installed Full Text Support option when installing SQL Express?

Thanks,

|||

I have just installed SQL 2005 Express with Advanced Services to test this out and it returns me all the languages fine :

lcid name

-- --

2052 Simplified Chinese

1028 Traditional Chinese

1031 German

2057 British English

1033 English

3082 Spanish

1036 French

1040 Italian

1041 Japanese

1042 Korean

0 Neutral

1043 Dutch

1053 Swedish

1054 Thai

3076 Chinese (Hong Kong SAR, PRC)

5124 Chinese (Macau SAR)

4100 Chinese (Singapore)

(17 row(s) affected)

Just make sure you have install Full Text Search option.

|||It was surely installed because msftesql.exe was running.

I reinstalled Sql Server Express with the following changes and now full-text search works:
- I use default instance instead of named instance
- IIS was enabled during installation
- The installation folder was selected so that to be different from the folder of previous installations.

Maybe the Sql Server 2005 wasn't removed correctly before installing Express and some components had conflict with each other. I don't know what the real reason was of the problem. The important thing is that now it works.
|||

Hi,

I Have the same problem, i execute the T-sql statement select*fromsys.fulltext_languages and i get zero rows, i uninstalled and installed again and nothing happend i still have zero when executing that statement, i try another computer and there evrything went fine!.. i do have Microsoft Net framework, and everything but i still can get this to work! help please!!!

|||Hello everybody, I am facing the same issue. It's really frustrating.
I have removed and reinstalled SQL Express 3 times, changed the installation path, but no hope.
I can't set it as the default instance since I'm using MSDE as default instance.
Any idea please?
|||

Are you sure you actually installed FTS; this feature is not installed by default, you must specifically select it from the feature list. Open up the SQL Configuration Manager and look at the Services node to verify that SQL Server FullText Search is listed and running.

If it's not listed, you didn't install it and you'll need to go into maintenance mode and select it from the feature list to get it installed.

Mike

|||

Hi,

I am having a similar problem. How do I go to maintenance mode? I also can't find anything called "SQL Configuration Manager".

cheers,

Bernie

|||

Hello Mike and thanks for the reply.
Of course I have installed FTS and it's listed in the configuration manager.
This problem is driving me crazy, it has taken 3 days from the tight timeframe of my project and I didn't find any solution.
I have removed MSDE, removed everything related to MsSql from the registry, deleted the installation directory, used "Windows install clean up" and reinstalled SQL Express with FTS as default instance may be more than 5 times and no hope.
Is there any way to install these damn languages manually? in the registry or whatever.
May be the problem is that SQL Express (without Advanced services) was installed previously and some trace is kept in the registry.
I don't know!
Any idea is really appreciated.

sql

No Default SQL Instance on Install?

Problem: When the application installs it requires SQL Express Server 2005. If it does not exist it will install it or rollback. -> continue installation -> When the form attempts to locate an SQL Instance on a machine that has not had SQL server or any components connected before it shows up as <null>. I need to have access to the server(s) instances in order to build the application database inside SQL. Am I using the wrong approach with SQLDMO? Is there adifferent method to access the installed SQL Express 2005 connection string?
Current code to locate SQL Instances:
try
{
////////////////////////////////////////
// Search and List SQL Server Instances
////////////////////////////////////////
//set cursor to thinking/hourglass
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.AppStarting;
//begin
ArrayList aServers = new ArrayList();
SQLDMO.ApplicationClass acServers = new SQLDMO.ApplicationClass();
//loop through the servers found
for (int iServerGroupCount = 1; iServerGroupCount <= acServers.ServerGroups.Count; iServerGroupCount++)
{
for (int iServerCount = 1; iServerCount <= acServers.ServerGroups.Item(iServerGroupCount).RegisteredServers.Count; iServerCount++)
{
aServers.Add(acServers.ServerGroups.Item(iServerGroupCount).RegisteredServers.Item(iServerCount).Name);
}
}
//add the servers to the drop down box
if (aServers.Count < 1)
{
string NotExist = "<No Servers Found>";
cboServers.Items.Add(NotExist);

cboServers.SelectedIndex = 0;
btnSQLDataBaseCheckDB.Enabled = false;

}
else
{
cboServers.Items.AddRange(aServers.ToArray());
//select the first item in the array index to display
cboServers.SelectedIndex = 0;
}
}
catch (Exception ServerException)
{
MessageBox.Show(ServerException.Message);
}

Slightly stuck at the moment with this. Any tips or leads in the right direction would be greatly appreciated.
sorry to double post. Found a relative link in the forums which may add some more insight to the problem, though certainly not solve it.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=385579&SiteID=1&mode=1

No connection limitation with SQL Express 2005?

MSDE had the limitation of 25 concurrent connections.
It seems that SQL Express 2005 doesn't have this limitation. Is that
correct? Does Express support as many connections as the "full" SQL 2005
server?"the friendly display name"
<thefriendlydisplayname@.discussions.microsoft.com> wrote in message
news:A0E3673D-E984-4EFA-82C2-1A51E6D38945@.microsoft.com...
> MSDE had the limitation of 25 concurrent connections.
No it didn't. It had a query governor which throttled performance after 5
concurrent workloads.

> It seems that SQL Express 2005 doesn't have this limitation. Is that
> correct?
Yes.

>Does Express support as many connections as the "full" SQL 2005
> server?
Yes. Althought SQL Server Express Edition is limited to 1GB of RAM and 1CPU
which will impose some limit on the number of users it can serve.
David|||Hi
And to add, there are no SQL Server limits, but if you run on Windows 2000
Pro or Windows XP, the OS has a limit of number of incoming network
connection it accepts, and that is 10.
On Server editions of the OS's, there are no limits.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:uxhcKhs5FHA.1864@.TK2MSFTNGP12.phx.gbl...
> "the friendly display name"
> <thefriendlydisplayname@.discussions.microsoft.com> wrote in message
> news:A0E3673D-E984-4EFA-82C2-1A51E6D38945@.microsoft.com...
> No it didn't. It had a query governor which throttled performance after 5
> concurrent workloads.
>
> Yes.
>
> Yes. Althought SQL Server Express Edition is limited to 1GB of RAM and
> 1CPU which will impose some limit on the number of users it can serve.
> David
>|||> And to add, there are no SQL Server limits, but if you run on Windows 2000
> Pro or Windows XP, the OS has a limit of number of incoming network
> connection it accepts, and that is 10.
IIRC, that is Redirector connections, not socket connections. Has anyone
tried more then 10 sql connections on XP?
William Stacey [MVP]sql

No connection limitation with SQL Express 2005?

MSDE had the limitation of 25 concurrent connections.
It seems that SQL Express 2005 doesn't have this limitation. Is that
correct? Does Express support as many connections as the "full" SQL 2005
server?"the friendly display name"
<thefriendlydisplayname@.discussions.microsoft.com> wrote in message
news:A0E3673D-E984-4EFA-82C2-1A51E6D38945@.microsoft.com...
> MSDE had the limitation of 25 concurrent connections.
No it didn't. It had a query governor which throttled performance after 5
concurrent workloads.
> It seems that SQL Express 2005 doesn't have this limitation. Is that
> correct?
Yes.
>Does Express support as many connections as the "full" SQL 2005
> server?
Yes. Althought SQL Server Express Edition is limited to 1GB of RAM and 1CPU
which will impose some limit on the number of users it can serve.
David|||Hi
And to add, there are no SQL Server limits, but if you run on Windows 2000
Pro or Windows XP, the OS has a limit of number of incoming network
connection it accepts, and that is 10.
On Server editions of the OS's, there are no limits.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:uxhcKhs5FHA.1864@.TK2MSFTNGP12.phx.gbl...
> "the friendly display name"
> <thefriendlydisplayname@.discussions.microsoft.com> wrote in message
> news:A0E3673D-E984-4EFA-82C2-1A51E6D38945@.microsoft.com...
>> MSDE had the limitation of 25 concurrent connections.
> No it didn't. It had a query governor which throttled performance after 5
> concurrent workloads.
>> It seems that SQL Express 2005 doesn't have this limitation. Is that
>> correct?
> Yes.
>>Does Express support as many connections as the "full" SQL 2005
>> server?
> Yes. Althought SQL Server Express Edition is limited to 1GB of RAM and
> 1CPU which will impose some limit on the number of users it can serve.
> David
>|||> And to add, there are no SQL Server limits, but if you run on Windows 2000
> Pro or Windows XP, the OS has a limit of number of incoming network
> connection it accepts, and that is 10.
IIRC, that is Redirector connections, not socket connections. Has anyone
tried more then 10 sql connections on XP?
--
William Stacey [MVP]

No connection limitation with SQL Express 2005?

MSDE had the limitation of 25 concurrent connections.
It seems that SQL Express 2005 doesn't have this limitation. Is that
correct? Does Express support as many connections as the "full" SQL 2005
server?
"the friendly display name"
<thefriendlydisplayname@.discussions.microsoft.com> wrote in message
news:A0E3673D-E984-4EFA-82C2-1A51E6D38945@.microsoft.com...
> MSDE had the limitation of 25 concurrent connections.
No it didn't. It had a query governor which throttled performance after 5
concurrent workloads.

> It seems that SQL Express 2005 doesn't have this limitation. Is that
> correct?
Yes.

>Does Express support as many connections as the "full" SQL 2005
> server?
Yes. Althought SQL Server Express Edition is limited to 1GB of RAM and 1CPU
which will impose some limit on the number of users it can serve.
David
|||Hi
And to add, there are no SQL Server limits, but if you run on Windows 2000
Pro or Windows XP, the OS has a limit of number of incoming network
connection it accepts, and that is 10.
On Server editions of the OS's, there are no limits.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:uxhcKhs5FHA.1864@.TK2MSFTNGP12.phx.gbl...
> "the friendly display name"
> <thefriendlydisplayname@.discussions.microsoft.com> wrote in message
> news:A0E3673D-E984-4EFA-82C2-1A51E6D38945@.microsoft.com...
> No it didn't. It had a query governor which throttled performance after 5
> concurrent workloads.
> Yes.
>
> Yes. Althought SQL Server Express Edition is limited to 1GB of RAM and
> 1CPU which will impose some limit on the number of users it can serve.
> David
>
|||> And to add, there are no SQL Server limits, but if you run on Windows 2000
> Pro or Windows XP, the OS has a limit of number of incoming network
> connection it accepts, and that is 10.
IIRC, that is Redirector connections, not socket connections. Has anyone
tried more then 10 sql connections on XP?
William Stacey [MVP]

No connection

Hello,

New development machine with Sql Server Express and Visual Web Developer.

I created a database then tried to connect from a test page on localhost and it worked. Then I tried from the internet domain and could not. So under the

Surface Area Configuration, I change the Remote Connections to Using both TCP/IP and named pipes and restarted the Database Engine. But

I still could not connect. So I restarted the machine. Now I can't view the page on localhost either. I can view a different web page so the Web server is

working.

I get the following as the exception:Error reading the database: Cannot open user default database. Login failed.Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

My connection string is: "Data Source=.\SQLEXPRESS;Integrated Security=True;AttachDBFilename=|DataDirectory|Externalresearch.mdf;User Instance=True"

Any suggestions?

Okay I found out why. If I have Web Developer open (with the database connection open) I cannot connect from the browser. But

if I close Web Developer then I can connect from the browser (ie, view my test page).

Is this because it's the same machine that I am both viewing the web page and hosting Sql server (ie, the user can only be used once)?

|||

Hi,

It's a little strange that it says you're using the Network Service to connect to SQL Server.

Are you connecting to the SQL Server through Internet with the windows authentication? If so, that's not supported, since the windows identity cannot be passed through internet.

|||

Kevin,

Everything including the database is on one machine. I'm using Windows authentication. So when I'm in Visual developer and connect

to the database, my web page (again hosted on the same machine) cannot connect to the database. It's a new installation of everything

with defaults setup. How can I work on the database while my web pages can still access the database? I just downloaded Managament

Studio Express, will this do?

Thanks for any help

|||

Hi,

Yes, you can use Management Studio to grant database access permission to the Network Service account.

By default, it does not have permission to the SQL Server. After granting the access, it will be working fine, I think.

sql

no "properties" option on stored procedures (cant set permissions)

SQL 2005 express.
I detached an SQL 2005 express database from server A and attached to SQL
2005 express on server B.
When i right click stored procedure from server A i see a PROPERITES
options.
When i do the same from server B ..... NO PROPERTIES option is available.
I view the SPs in both DBs using SQL Express Mgt studio. Both managers are
logged in as SA.
Any ideas ?
Thank
Scott
---
http://www.sage-eshop.comJust a wild guess:
Perhaps the owner of the database isn't a login on server B? See sp_changedbowner.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Scott" <http://www.sage-eshop.com> wrote in message news:uommvsq9GHA.2268@.TK2MSFTNGP05.phx.gbl...
> SQL 2005 express.
> I detached an SQL 2005 express database from server A and attached to SQL
> 2005 express on server B.
> When i right click stored procedure from server A i see a PROPERITES
> options.
> When i do the same from server B ..... NO PROPERTIES option is available.
> I view the SPs in both DBs using SQL Express Mgt studio. Both managers are
> logged in as SA.
> Any ideas ?
> Thank
> Scott
> ---
> http://www.sage-eshop.com
>|||thanks for reply.
i can see sp_changedbowner, it executes ok.
im not exactly sure what i should do with it now.
scott.|||My guess is that the owner for the database (the SID) doesn't exist as a login in the master
database. Try setting the owner to sa, for instance.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Scott" <http://www.sage-eshop.com> wrote in message
news:uF%233%23Hr9GHA.4012@.TK2MSFTNGP04.phx.gbl...
> thanks for reply.
> i can see sp_changedbowner, it executes ok.
> im not exactly sure what i should do with it now.
> scott.
>|||i created a new DB and new SP and still dont get the properties.
if the user has the ability to create a DB and SPs in the db, they should
have the ability to view/amend properties.|||Might be a bug in the GUI you are using. If you are using the express version of management studio,
you might want to post to an express group. I didn't find such on this news server, but you can try
the HTTP groups:
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=385&SiteID=1
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Scott" <http://www.sage-eshop.com> wrote in message news:et40aRr9GHA.3352@.TK2MSFTNGP03.phx.gbl...
>i created a new DB and new SP and still dont get the properties.
> if the user has the ability to create a DB and SPs in the db, they should have the ability to
> view/amend properties.
>|||Hi ..
I'm getting exactly the same issue.. We've gone and created our
databases in SQL Express, but have a code generator that needs to look
at extended proeprties on the stored procedures. In SQL Express
databases, the Properties option is not available for SP's,
Personally I just think this is a bug in the Management Studio UI too,
as Properties is available for the other objects such as Tables,
Databases (do it's not that SQL Express doesn't supoprt Extended
Properties, which was my first guess).
If you get any luck, please post a message here.
Scott wrote:
> i created a new DB and new SP and still dont get the properties.
> if the user has the ability to create a DB and SPs in the db, they should
> have the ability to view/amend properties.

NHibernate mapping

I'm using NHibernate with SQL Server Express Edition and I've been problems with the data type to be defined in the "type" attribute on the "property" tag in the XML file mapping.

Has someone worked with that?

I need to match the appropriate NHibernate type to the following SQL Server Types:

uniqueidentifier;bit;ntext;

I have been getting "type mismatch" error when the code is trying access the data.

Thanks a lot!

Hi oalexandrino,

Could you please post your detailed mapping schema here so we can better help you? Seems your problem is caused by uniqueidentifier. Anyway, I have read an article and it says you can configure your mapping file like this:

To map to a SQL Server instance, here is what your configuration settings might look like:

<configuration> <configSections><section name="nhibernate" type="System.Configuration.NameValueSectionHandler, System,Version=1.0.5000.0,Culture=neutral,PublicKeyToken=b77a5c561934e089" /> </configSections> <nhibernate><add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider"/><add key="hibernate.dialect" value="NHibernate.Dialect.MsSql2000Dialect"/><add key="hibernate.connection.driver_class" value="NHibernate.Driver.SqlClientDriver" /><add key="hibernate.connection.connection_string" value="Server=localhost;initial catalog=nhibernate;UserID=someuser;Password=somepwd;Min Pool Size=2"/></nhibernate></configuration>

There are also some other steps you need to follow, see:http://www.theserverside.net/tt/articles/showarticle.tss?id=NHibernate It should help you solve your prolbem.Thanks

This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

|||

helloChen!

Firstly thanks by your answer.

So, in order to solve my problem I looked for something around internet to extract automatically this XML according to database schema.

Then I found thisSmartCode

http://www.codeproject.com/useritems/SmartCode-Code_Generation.asp

It is a useful tool because reading the tables in database and creates for each one an NHibernate mapping with all .NET types according with SQL types in the database.

That gave me what problem I was getting!

thanks!