Cant get linq to recognize that sproc has changed

I have a GridView that is populated by a stored procedure via linq. I changed the stored procedure to return an additional column, but I can't get the additional column to show up in the GridView. The GridView has autogeneratecolumns=true, so if I were using a SqlDataSource the new column would show up automagically. But now it is not showing up and I cannot reference it. I can't figure out how to make linq recognize that my stored procedure has changed.

I have tried deleting the sproc definition from the dbml file, making sure the partial class is removed the .vb file, refreshing the stored procedures list in database explorer, and adding the sproc definition back again (a hassle), but still it insists on defining only the original columns and not the new column.

How do get linq to get back in sync with the database?

Is there any way to get linq back in sync after database changes??

sql

can''t create reports via VS 2005 Standard

From what I read about the versions, VS 2005 Standard allows for SSRS development.

If I create a new project, I don't see the option to create anything from the BI section to create a report project.

I have SQL Server Express on my machine, and am able to run the SSRS configuartion management tool.

Do I have to run an .exe file or something?

Thanks!

When you installed SQL, did you expand all of the components and specify that you WANT them to be installed? For some reason they all default to do NOT intall.

I believe there is a component in client components (business intelligence studio) or something like that which actually installs the SQL server report project to Visual Studio.

Yes, Visual Studio comes with a menu in the create project wizard for Business Intelligence Projects. However, there are most likely no project types in that section for you, because the proper components were not installed when SQL was installed.

|||You have to install the SQL Server 2005 workstation tools including the Business Intelligence Studio AFTER VS 2005 is installed, and several new modules will show in the VS2005 startup splash, and new project types will be available.

If this still does not appear properly, you may need to rebuild your project templates. I took me a couple re-installs to get it right.
|||

did a re-install of the tool set which includes the BI templates and that worked.

Thanks!

can''t create reports via VS 2005 Standard

From what I read about the versions, VS 2005 Standard allows for SSRS development.

If I create a new project, I don't see the option to create anything from the BI section to create a report project.

I have SQL Server Express on my machine, and am able to run the SSRS configuartion management tool.

Do I have to run an .exe file or something?

Thanks!

When you installed SQL, did you expand all of the components and specify that you WANT them to be installed? For some reason they all default to do NOT intall.

I believe there is a component in client components (business intelligence studio) or something like that which actually installs the SQL server report project to Visual Studio.

Yes, Visual Studio comes with a menu in the create project wizard for Business Intelligence Projects. However, there are most likely no project types in that section for you, because the proper components were not installed when SQL was installed.

|||You have to install the SQL Server 2005 workstation tools including the Business Intelligence Studio AFTER VS 2005 is installed, and several new modules will show in the VS2005 startup splash, and new project types will be available.

If this still does not appear properly, you may need to rebuild your project templates. I took me a couple re-installs to get it right.
|||

did a re-install of the tool set which includes the BI templates and that worked.

Thanks!

can''t create reports via VS 2005 Standard

From what I read about the versions, VS 2005 Standard allows for SSRS development.

If I create a new project, I don't see the option to create anything from the BI section to create a report project.

I have SQL Server Express on my machine, and am able to run the SSRS configuartion management tool.

Do I have to run an .exe file or something?

Thanks!

When you installed SQL, did you expand all of the components and specify that you WANT them to be installed? For some reason they all default to do NOT intall.

I believe there is a component in client components (business intelligence studio) or something like that which actually installs the SQL server report project to Visual Studio.

Yes, Visual Studio comes with a menu in the create project wizard for Business Intelligence Projects. However, there are most likely no project types in that section for you, because the proper components were not installed when SQL was installed.

|||You have to install the SQL Server 2005 workstation tools including the Business Intelligence Studio AFTER VS 2005 is installed, and several new modules will show in the VS2005 startup splash, and new project types will be available.

If this still does not appear properly, you may need to rebuild your project templates. I took me a couple re-installs to get it right.
|||

did a re-install of the tool set which includes the BI templates and that worked.

Thanks!

can''t create reports via VS 2005 Standard

From what I read about the versions, VS 2005 Standard allows for SSRS development.

If I create a new project, I don't see the option to create anything from the BI section to create a report project.

I have SQL Server Express on my machine, and am able to run the SSRS configuartion management tool.

Do I have to run an .exe file or something?

Thanks!

When you installed SQL, did you expand all of the components and specify that you WANT them to be installed? For some reason they all default to do NOT intall.

I believe there is a component in client components (business intelligence studio) or something like that which actually installs the SQL server report project to Visual Studio.

Yes, Visual Studio comes with a menu in the create project wizard for Business Intelligence Projects. However, there are most likely no project types in that section for you, because the proper components were not installed when SQL was installed.

|||You have to install the SQL Server 2005 workstation tools including the Business Intelligence Studio AFTER VS 2005 is installed, and several new modules will show in the VS2005 startup splash, and new project types will be available.

If this still does not appear properly, you may need to rebuild your project templates. I took me a couple re-installs to get it right.
|||

did a re-install of the tool set which includes the BI templates and that worked.

Thanks!

Can't Create New Database on Device via ActiveSync

In VS2005 RTM using

Server Explorer -->
Right Click DATA CONNECTIONS -->
Add Connection -->
Datasource=Microsoft SQL Server Mobile Edition--> Data provider = .NET Framework Data Provider for SQL Server Mobile Edition-->
ActiveSync Connected Device

when I hit Test Connection I hear ActiveSync's connect sound and I get this error

Microsoft Development Environment

Microsoft 5QL Server 2005 Mobile Edition and/or NET Compact Framework v2.0 is not properly installed on your mobile device or the device is not responding.

OK

Has anyone experienced this? I can very easily create the database on my desktop, but even though the option to use activeSync is offered, it does not appear to work in VS 2005 RTM.

Is that true?

Thanks,

Wil Pannell

Hi Wil,

Creating a DB on a device over Active Sync is a prime feature and it works very well too in VS 2005 RTM.

Here are the things you should check:
1) Did Active Sync detect the connection and turned green?. And, which Active Sync version are you using, Is it the latest or the old?
2) Is your device running the supported Windows CE Version?
3) Are you able to browse files & folders on the device using Windows Explorer?
4) Did you do any uninstallations and installations in the mean time? Check whether the SQL Mobile data provider is listed in .NET Framework config file machine.config.

Hope this helps!

Thanks,
Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation|||I'm having this problem as well.

Wil, did you sort it out in the end?
|||

Did you verify the things specified above? And, still facing the same problem, then let me know.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||Yes everything was still not working correctly and I reinstalled everythnig.

Turned out that VS2005 wasn't depolying CF2 and the SQL Mobile Database engine properly on the device or the emulator.

I had to manually install the CF2 and the SQL mobile DB engine for it to work. The error message VS2005 gave didn't help at all with tracking this down.
|||

Glad that things are working on your end.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||I have the same problem to at Visual Studio. I try to fix the error using this step.
1. I install the compact framework using NETCFv2.wm.armv4i.cab file. Status done.
2. I install the SQL CE database server using Mobile first, you can find it at folder
drive:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce500\armv4i
The file list are :
- sqlce30.dev.ENU.ppc.wce5.armv4i.CAB
- sqlce30.ppc.wce5.armv4i.CAB
- sqlce30.repl.ppc.wce5.armv4i.CAB
3. I've got the error like described above, the error also raised on Emulator too, so i uninstall the SQLCE
4. I instal the SQL using Client, you can find it at folder :
drive:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Client\v2.0\wce500\armv4i
The file list are :
- sql.dev.ENU.ppc.wce5.armv4i.CAB
- sql.ppc.wce5.armv4i.CAB
5. There no error again on Emulator, but on Visual Studio still have the same error.

Ok then where is the problem, Thanks.

PS: I use WM5 Pocket PC Emulator and the Visual Studio is VS2005
|||If you have uninstalled and reinstalled .NET Fx after VS Installation, this problem would arise. Can you please search for Data Providers in .NET Framework config file.

%SystemDrive%\WINDOWS\Microsoft.NET\Framework\v2.0.xxxxx\config\machine.config

Open this file in NOTEPAD, and search for "SQL Server CE Data Provider". If it is not there then, you may try adding the following line AS IT IS in Data Providers section.

<add name="SQL Server CE Data Provider" invariant="Microsoft.SqlServerCe.Client" description=".NET Framework Data Provider for Microsoft SQL Server 2005 Mobile Edition" type="Microsoft.SqlServerCe.Client.SqlCeClientFactory, Microsoft.SqlServerCe.Client, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />

You may need to restart the VS or even the PC to make VS detect this new setting.

Let us know if this has worked for you!

Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||

I also faced this problem and have tried to solve it. Finally, I myself found one that I never thought before.

You can simply run sqlmobile30devtoolsenu.msi file again to install Mobile Development Tool. This file comes with the VS 2005 Pro distribution in wcu\SQLCE folder.

Hope that help!

QUAN,

I love this site!

|||

Thanks for posting back on how you solved it. However, I can not guess what went wrong in the first installation!

Thanks

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

|||1) Did Active Sync detect the connection and turned green?. And, which Active Sync version are you using, Is it the latest or the old?
YES, Version 4.1
2) Is your device running the supported Windows CE Version?
Yes
3) Are you able to browse files & folders on the device using Windows Explorer?
Yes
4) Did you do any uninstallations and installations in the mean time? Check whether the SQL Mobile data provider is listed in .NET Framework config file machine.config.
Yes, it's listed
Any ideas?
Thank you very much...|||I had the same problem. After trying the suggested solutions, I installed it manually and it worked. (see http://msdn2.microsoft.com/en-us/library/ms171875.aspx)|||
Como fa?o para aparecer o Microsoft Sql Server Mobile Edition na tela de Change Data Source?
Teria como me ajudar?
Já instalei tudo e n?o aparece, at mesmo mudei o maching.config e n?o funcionou.
Pode me ajudar?

Can't Create New Database on Device via ActiveSync

In VS2005 RTM using

Server Explorer -->
Right Click DATA CONNECTIONS -->
Add Connection -->
Datasource=Microsoft SQL Server Mobile Edition--> Data provider = .NET Framework Data Provider for SQL Server Mobile Edition-->
ActiveSync Connected Device

when I hit Test Connection I hear ActiveSync's connect sound and I get this error

Microsoft Development Environment

Microsoft 5QL Server 2005 Mobile Edition and/or NET Compact Framework v2.0 is not properly installed on your mobile device or the device is not responding.

OK

Has anyone experienced this? I can very easily create the database on my desktop, but even though the option to use activeSync is offered, it does not appear to work in VS 2005 RTM.

Is that true?

Thanks,

Wil Pannell

Hi Wil,

Creating a DB on a device over Active Sync is a prime feature and it works very well too in VS 2005 RTM.

Here are the things you should check:
1) Did Active Sync detect the connection and turned green?. And, which Active Sync version are you using, Is it the latest or the old?
2) Is your device running the supported Windows CE Version?
3) Are you able to browse files & folders on the device using Windows Explorer?
4) Did you do any uninstallations and installations in the mean time? Check whether the SQL Mobile data provider is listed in .NET Framework config file machine.config.

Hope this helps!

Thanks,
Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation|||I'm having this problem as well.

Wil, did you sort it out in the end?
|||

Did you verify the things specified above? And, still facing the same problem, then let me know.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||Yes everything was still not working correctly and I reinstalled everythnig.

Turned out that VS2005 wasn't depolying CF2 and the SQL Mobile Database engine properly on the device or the emulator.

I had to manually install the CF2 and the SQL mobile DB engine for it to work. The error message VS2005 gave didn't help at all with tracking this down.
|||

Glad that things are working on your end.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||I have the same problem to at Visual Studio. I try to fix the error using this step.
1. I install the compact framework using NETCFv2.wm.armv4i.cab file. Status done.
2. I install the SQL CE database server using Mobile first, you can find it at folder
drive:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce500\armv4i
The file list are :
- sqlce30.dev.ENU.ppc.wce5.armv4i.CAB
- sqlce30.ppc.wce5.armv4i.CAB
- sqlce30.repl.ppc.wce5.armv4i.CAB
3. I've got the error like described above, the error also raised on Emulator too, so i uninstall the SQLCE
4. I instal the SQL using Client, you can find it at folder :
drive:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Client\v2.0\wce500\armv4i
The file list are :
- sql.dev.ENU.ppc.wce5.armv4i.CAB
- sql.ppc.wce5.armv4i.CAB
5. There no error again on Emulator, but on Visual Studio still have the same error.

Ok then where is the problem, Thanks.

PS: I use WM5 Pocket PC Emulator and the Visual Studio is VS2005
|||If you have uninstalled and reinstalled .NET Fx after VS Installation, this problem would arise. Can you please search for Data Providers in .NET Framework config file.

%SystemDrive%\WINDOWS\Microsoft.NET\Framework\v2.0.xxxxx\config\machine.config

Open this file in NOTEPAD, and search for "SQL Server CE Data Provider". If it is not there then, you may try adding the following line AS IT IS in Data Providers section.

<add name="SQL Server CE Data Provider" invariant="Microsoft.SqlServerCe.Client" description=".NET Framework Data Provider for Microsoft SQL Server 2005 Mobile Edition" type="Microsoft.SqlServerCe.Client.SqlCeClientFactory, Microsoft.SqlServerCe.Client, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />

You may need to restart the VS or even the PC to make VS detect this new setting.

Let us know if this has worked for you!

Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||

I also faced this problem and have tried to solve it. Finally, I myself found one that I never thought before.

You can simply run sqlmobile30devtoolsenu.msi file again to install Mobile Development Tool. This file comes with the VS 2005 Pro distribution in wcu\SQLCE folder.

Hope that help!

QUAN,

I love this site!

|||

Thanks for posting back on how you solved it. However, I can not guess what went wrong in the first installation!

Thanks

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

|||1) Did Active Sync detect the connection and turned green?. And, which Active Sync version are you using, Is it the latest or the old?
YES, Version 4.1
2) Is your device running the supported Windows CE Version?
Yes
3) Are you able to browse files & folders on the device using Windows Explorer?
Yes
4) Did you do any uninstallations and installations in the mean time? Check whether the SQL Mobile data provider is listed in .NET Framework config file machine.config.
Yes, it's listed
Any ideas?
Thank you very much...|||I had the same problem. After trying the suggested solutions, I installed it manually and it worked. (see http://msdn2.microsoft.com/en-us/library/ms171875.aspx)|||
Como fa?o para aparecer o Microsoft Sql Server Mobile Edition na tela de Change Data Source?
Teria como me ajudar?
Já instalei tudo e n?o aparece, at mesmo mudei o maching.config e n?o funcionou.
Pode me ajudar?

Can't Create New Database on Device via ActiveSync

In VS2005 RTM using

Server Explorer -->
Right Click DATA CONNECTIONS -->
Add Connection -->
Datasource=Microsoft SQL Server Mobile Edition--> Data provider = .NET Framework Data Provider for SQL Server Mobile Edition-->
ActiveSync Connected Device

when I hit Test Connection I hear ActiveSync's connect sound and I get this error

Microsoft Development Environment

Microsoft 5QL Server 2005 Mobile Edition and/or NET Compact Framework v2.0 is not properly installed on your mobile device or the device is not responding.

OK

Has anyone experienced this? I can very easily create the database on my desktop, but even though the option to use activeSync is offered, it does not appear to work in VS 2005 RTM.

Is that true?

Thanks,

Wil Pannell

Hi Wil,

Creating a DB on a device over Active Sync is a prime feature and it works very well too in VS 2005 RTM.

Here are the things you should check:
1) Did Active Sync detect the connection and turned green?. And, which Active Sync version are you using, Is it the latest or the old?
2) Is your device running the supported Windows CE Version?
3) Are you able to browse files & folders on the device using Windows Explorer?
4) Did you do any uninstallations and installations in the mean time? Check whether the SQL Mobile data provider is listed in .NET Framework config file machine.config.

Hope this helps!

Thanks,
Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation|||I'm having this problem as well.

Wil, did you sort it out in the end?|||

Did you verify the things specified above? And, still facing the same problem, then let me know.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||Yes everything was still not working correctly and I reinstalled everythnig.

Turned out that VS2005 wasn't depolying CF2 and the SQL Mobile Database engine properly on the device or the emulator.

I had to manually install the CF2 and the SQL mobile DB engine for it to work. The error message VS2005 gave didn't help at all with tracking this down.|||

Glad that things are working on your end.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||I have the same problem to at Visual Studio. I try to fix the error using this step.
1. I install the compact framework using NETCFv2.wm.armv4i.cab file. Status done.
2. I install the SQL CE database server using Mobile first, you can find it at folder
drive:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce500\armv4i
The file list are :
- sqlce30.dev.ENU.ppc.wce5.armv4i.CAB
- sqlce30.ppc.wce5.armv4i.CAB
- sqlce30.repl.ppc.wce5.armv4i.CAB
3. I've got the error like described above, the error also raised on Emulator too, so i uninstall the SQLCE
4. I instal the SQL using Client, you can find it at folder :
drive:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Client\v2.0\wce500\armv4i
The file list are :
- sql.dev.ENU.ppc.wce5.armv4i.CAB
- sql.ppc.wce5.armv4i.CAB
5. There no error again on Emulator, but on Visual Studio still have the same error.

Ok then where is the problem, Thanks.

PS: I use WM5 Pocket PC Emulator and the Visual Studio is VS2005|||If you have uninstalled and reinstalled .NET Fx after VS Installation, this problem would arise. Can you please search for Data Providers in .NET Framework config file.

%SystemDrive%\WINDOWS\Microsoft.NET\Framework\v2.0.xxxxx\config\machine.config

Open this file in NOTEPAD, and search for "SQL Server CE Data Provider". If it is not there then, you may try adding the following line AS IT IS in Data Providers section.

<add name="SQL Server CE Data Provider" invariant="Microsoft.SqlServerCe.Client" description=".NET Framework Data Provider for Microsoft SQL Server 2005 Mobile Edition" type="Microsoft.SqlServerCe.Client.SqlCeClientFactory, Microsoft.SqlServerCe.Client, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />

You may need to restart the VS or even the PC to make VS detect this new setting.

Let us know if this has worked for you!

Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||

I also faced this problem and have tried to solve it. Finally, I myself found one that I never thought before.

You can simply run sqlmobile30devtoolsenu.msi file again to install Mobile Development Tool. This file comes with the VS 2005 Pro distribution in wcu\SQLCE folder.

Hope that help!

QUAN,

I love this site!

|||

Thanks for posting back on how you solved it. However, I can not guess what went wrong in the first installation!

Thanks

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

|||

1) Did Active Sync detect the connection and turned green?. And, which

Active Sync version are you using, Is it the latest or the old?

YES, Version 4.1

2) Is your device running the supported Windows CE Version?

Yes

3) Are you able to browse files & folders on the device using Windows Explorer?

Yes

4) Did you do any uninstallations and installations in the mean time?

Check whether the SQL Mobile data provider is listed in .NET Framework

config file machine.config.

Yes, it's listed

Any ideas?

Thank you very much...|||I had the same problem. After trying the suggested solutions, I installed it manually and it worked. (see http://msdn2.microsoft.com/en-us/library/ms171875.aspx)|||
Como fa?o para aparecer o Microsoft Sql Server Mobile Edition na tela de Change Data Source?
Teria como me ajudar?
Já instalei tudo e n?o aparece, at mesmo mudei o maching.config e n?o funcionou.
Pode me ajudar?

Can't Create New Database on Device via ActiveSync

In VS2005 RTM using

Server Explorer -->
Right Click DATA CONNECTIONS -->
Add Connection -->
Datasource=Microsoft SQL Server Mobile Edition--> Data provider = .NET Framework Data Provider for SQL Server Mobile Edition-->
ActiveSync Connected Device

when I hit Test Connection I hear ActiveSync's connect sound and I get this error

Microsoft Development Environment

Microsoft 5QL Server 2005 Mobile Edition and/or NET Compact Framework v2.0 is not properly installed on your mobile device or the device is not responding.

OK

Has anyone experienced this? I can very easily create the database on my desktop, but even though the option to use activeSync is offered, it does not appear to work in VS 2005 RTM.

Is that true?

Thanks,

Wil Pannell

Hi Wil,

Creating a DB on a device over Active Sync is a prime feature and it works very well too in VS 2005 RTM.

Here are the things you should check:
1) Did Active Sync detect the connection and turned green?. And, which Active Sync version are you using, Is it the latest or the old?
2) Is your device running the supported Windows CE Version?
3) Are you able to browse files & folders on the device using Windows Explorer?
4) Did you do any uninstallations and installations in the mean time? Check whether the SQL Mobile data provider is listed in .NET Framework config file machine.config.

Hope this helps!

Thanks,
Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation|||I'm having this problem as well.

Wil, did you sort it out in the end?
|||

Did you verify the things specified above? And, still facing the same problem, then let me know.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||Yes everything was still not working correctly and I reinstalled everythnig.

Turned out that VS2005 wasn't depolying CF2 and the SQL Mobile Database engine properly on the device or the emulator.

I had to manually install the CF2 and the SQL mobile DB engine for it to work. The error message VS2005 gave didn't help at all with tracking this down.
|||

Glad that things are working on your end.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||I have the same problem to at Visual Studio. I try to fix the error using this step.
1. I install the compact framework using NETCFv2.wm.armv4i.cab file. Status done.
2. I install the SQL CE database server using Mobile first, you can find it at folder
drive:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce500\armv4i
The file list are :
- sqlce30.dev.ENU.ppc.wce5.armv4i.CAB
- sqlce30.ppc.wce5.armv4i.CAB
- sqlce30.repl.ppc.wce5.armv4i.CAB
3. I've got the error like described above, the error also raised on Emulator too, so i uninstall the SQLCE
4. I instal the SQL using Client, you can find it at folder :
drive:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Client\v2.0\wce500\armv4i
The file list are :
- sql.dev.ENU.ppc.wce5.armv4i.CAB
- sql.ppc.wce5.armv4i.CAB
5. There no error again on Emulator, but on Visual Studio still have the same error.

Ok then where is the problem, Thanks.

PS: I use WM5 Pocket PC Emulator and the Visual Studio is VS2005
|||If you have uninstalled and reinstalled .NET Fx after VS Installation, this problem would arise. Can you please search for Data Providers in .NET Framework config file.

%SystemDrive%\WINDOWS\Microsoft.NET\Framework\v2.0.xxxxx\config\machine.config

Open this file in NOTEPAD, and search for "SQL Server CE Data Provider". If it is not there then, you may try adding the following line AS IT IS in Data Providers section.

<add name="SQL Server CE Data Provider" invariant="Microsoft.SqlServerCe.Client" description=".NET Framework Data Provider for Microsoft SQL Server 2005 Mobile Edition" type="Microsoft.SqlServerCe.Client.SqlCeClientFactory, Microsoft.SqlServerCe.Client, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />

You may need to restart the VS or even the PC to make VS detect this new setting.

Let us know if this has worked for you!

Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||

I also faced this problem and have tried to solve it. Finally, I myself found one that I never thought before.

You can simply run sqlmobile30devtoolsenu.msi file again to install Mobile Development Tool. This file comes with the VS 2005 Pro distribution in wcu\SQLCE folder.

Hope that help!

QUAN,

I love this site!

|||

Thanks for posting back on how you solved it. However, I can not guess what went wrong in the first installation!

Thanks

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

|||1) Did Active Sync detect the connection and turned green?. And, which Active Sync version are you using, Is it the latest or the old?
YES, Version 4.1
2) Is your device running the supported Windows CE Version?
Yes
3) Are you able to browse files & folders on the device using Windows Explorer?
Yes
4) Did you do any uninstallations and installations in the mean time? Check whether the SQL Mobile data provider is listed in .NET Framework config file machine.config.
Yes, it's listed
Any ideas?
Thank you very much...|||I had the same problem. After trying the suggested solutions, I installed it manually and it worked. (see http://msdn2.microsoft.com/en-us/library/ms171875.aspx)|||
Como fa?o para aparecer o Microsoft Sql Server Mobile Edition na tela de Change Data Source?
Teria como me ajudar?
Já instalei tudo e n?o aparece, at mesmo mudei o maching.config e n?o funcionou.
Pode me ajudar?

Can't Create New Database on Device via ActiveSync

In VS2005 RTM using

Server Explorer -->
Right Click DATA CONNECTIONS -->
Add Connection -->
Datasource=Microsoft SQL Server Mobile Edition--> Data provider = .NET Framework Data Provider for SQL Server Mobile Edition-->
ActiveSync Connected Device

when I hit Test Connection I hear ActiveSync's connect sound and I get this error

Microsoft Development Environment

Microsoft 5QL Server 2005 Mobile Edition and/or NET Compact Framework v2.0 is not properly installed on your mobile device or the device is not responding.

OK

Has anyone experienced this? I can very easily create the database on my desktop, but even though the option to use activeSync is offered, it does not appear to work in VS 2005 RTM.

Is that true?

Thanks,

Wil Pannell

Hi Wil,

Creating a DB on a device over Active Sync is a prime feature and it works very well too in VS 2005 RTM.

Here are the things you should check:
1) Did Active Sync detect the connection and turned green?. And, which Active Sync version are you using, Is it the latest or the old?
2) Is your device running the supported Windows CE Version?
3) Are you able to browse files & folders on the device using Windows Explorer?
4) Did you do any uninstallations and installations in the mean time? Check whether the SQL Mobile data provider is listed in .NET Framework config file machine.config.

Hope this helps!

Thanks,
Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation|||I'm having this problem as well.

Wil, did you sort it out in the end?|||

Did you verify the things specified above? And, still facing the same problem, then let me know.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||Yes everything was still not working correctly and I reinstalled everythnig.

Turned out that VS2005 wasn't depolying CF2 and the SQL Mobile Database engine properly on the device or the emulator.

I had to manually install the CF2 and the SQL mobile DB engine for it to work. The error message VS2005 gave didn't help at all with tracking this down.|||

Glad that things are working on your end.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||I have the same problem to at Visual Studio. I try to fix the error using this step.
1. I install the compact framework using NETCFv2.wm.armv4i.cab file. Status done.
2. I install the SQL CE database server using Mobile first, you can find it at folder
drive:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce500\armv4i
The file list are :
- sqlce30.dev.ENU.ppc.wce5.armv4i.CAB
- sqlce30.ppc.wce5.armv4i.CAB
- sqlce30.repl.ppc.wce5.armv4i.CAB
3. I've got the error like described above, the error also raised on Emulator too, so i uninstall the SQLCE
4. I instal the SQL using Client, you can find it at folder :
drive:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Client\v2.0\wce500\armv4i
The file list are :
- sql.dev.ENU.ppc.wce5.armv4i.CAB
- sql.ppc.wce5.armv4i.CAB
5. There no error again on Emulator, but on Visual Studio still have the same error.

Ok then where is the problem, Thanks.

PS: I use WM5 Pocket PC Emulator and the Visual Studio is VS2005|||If you have uninstalled and reinstalled .NET Fx after VS Installation, this problem would arise. Can you please search for Data Providers in .NET Framework config file.

%SystemDrive%\WINDOWS\Microsoft.NET\Framework\v2.0.xxxxx\config\machine.config

Open this file in NOTEPAD, and search for "SQL Server CE Data Provider". If it is not there then, you may try adding the following line AS IT IS in Data Providers section.

<add name="SQL Server CE Data Provider" invariant="Microsoft.SqlServerCe.Client" description=".NET Framework Data Provider for Microsoft SQL Server 2005 Mobile Edition" type="Microsoft.SqlServerCe.Client.SqlCeClientFactory, Microsoft.SqlServerCe.Client, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />

You may need to restart the VS or even the PC to make VS detect this new setting.

Let us know if this has worked for you!

Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||

I also faced this problem and have tried to solve it. Finally, I myself found one that I never thought before.

You can simply run sqlmobile30devtoolsenu.msi file again to install Mobile Development Tool. This file comes with the VS 2005 Pro distribution in wcu\SQLCE folder.

Hope that help!

QUAN,

I love this site!

|||

Thanks for posting back on how you solved it. However, I can not guess what went wrong in the first installation!

Thanks

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

|||

1) Did Active Sync detect the connection and turned green?. And, which

Active Sync version are you using, Is it the latest or the old?

YES, Version 4.1

2) Is your device running the supported Windows CE Version?

Yes

3) Are you able to browse files & folders on the device using Windows Explorer?

Yes

4) Did you do any uninstallations and installations in the mean time?

Check whether the SQL Mobile data provider is listed in .NET Framework

config file machine.config.

Yes, it's listed

Any ideas?

Thank you very much...|||I had the same problem. After trying the suggested solutions, I installed it manually and it worked. (see http://msdn2.microsoft.com/en-us/library/ms171875.aspx)|||
Como fa?o para aparecer o Microsoft Sql Server Mobile Edition na tela de Change Data Source?
Teria como me ajudar?
Já instalei tudo e n?o aparece, at mesmo mudei o maching.config e n?o funcionou.
Pode me ajudar?

Can't connect via HTTP remotely...

Hello-

I've just set up HTTP Access to SSAS and can connect locally, but when trying to connect remotely, as the same domain user, I receive the message:

The connection either timed out or was lost

Unable to connect to the remote server

No connection could be made because the target machine actively refused it

I can connect remotely if I connect using just the servername (rather than http://...)

Anyone else runinto this one?

Hi Tristan,

For troubleshooting connectivity problems, one great resource is Edward's blog at: http://www.sqljunkies.com/WebLog/edwardm/.

If you still have connectivity issues after following the guidelines described in this blog, please let us know and give more details.

Hope this helps,

Artur

Can't connect via Enterprise Manager

Hi All,
We have a MSDE on a W2K server installed. It is running fine and the
application can access it without a problem. We have another server on that
same subnet that has an SQL 2000 server installed. When trying to connect to
the MSDE via the Enterprise Manager, only the local SQL shows up and we
cannot connect to the MSDE instance.
When we go to the ODBC on the MSDE box we see both SQL - the local and the
remote one. On the ODBC on the other server we only see the local one.
Does anybody have an idea what is going on?
Thanks,
Claus
Hi Claus,
Most likely network protocols not enabled. Run svrnetcn.exe and check which
protocols (eg tcp) are enabled. By default, none are.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"cjobes" <cjobes@.nova-tech.org> wrote in message
news:%234wb4E1oEHA.4044@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> We have a MSDE on a W2K server installed. It is running fine and the
> application can access it without a problem. We have another server on
that
> same subnet that has an SQL 2000 server installed. When trying to connect
to
> the MSDE via the Enterprise Manager, only the local SQL shows up and we
> cannot connect to the MSDE instance.
> When we go to the ODBC on the MSDE box we see both SQL - the local and the
> remote one. On the ODBC on the other server we only see the local one.
> Does anybody have an idea what is going on?
> Thanks,
> Claus
>
|||Hi Greg,
Thanks for the answer. I double checked and both protocols (tcp and named
pipe) are enabled.
Claus
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:%23LcQb96oEHA.1160@.tk2msftngp13.phx.gbl...
> Hi Claus,
> Most likely network protocols not enabled. Run svrnetcn.exe and check
which[vbcol=seagreen]
> protocols (eg tcp) are enabled. By default, none are.
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "cjobes" <cjobes@.nova-tech.org> wrote in message
> news:%234wb4E1oEHA.4044@.TK2MSFTNGP10.phx.gbl...
> that
connect[vbcol=seagreen]
> to
the
>
|||Claus,
Have you checked the firewall settings on the second server? If it has
the TCP port used by MSDE blocked you won't be able to connect.
Ron Allen
"cjobes" <cjobes@.nova-tech.org> wrote in message
news:%23WJfzS9oEHA.3460@.tk2msftngp13.phx.gbl...
> Hi Greg,
> Thanks for the answer. I double checked and both protocols (tcp and named
> pipe) are enabled.
> Claus
> "Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
> news:%23LcQb96oEHA.1160@.tk2msftngp13.phx.gbl...
> which
> connect
> the
>
|||Hi Claus,
I might need more inputs to trouble shoot this issue. Before this, you
could try Re- registering the MSDE Server in your Enterprise Manager.
Please use the Register SQL Server Wizard. For the sake of Clarity, I am
outling the steps here.
In the Enterprise Manager, If the MSDE Server is already
Registered, then Select Server, Right Click on the Server and Select Delete
SQL Server Registration.
1. In the Enterprise Manager, Start Register SQL Server Wizard. (Right
Click on SQL Server Group, Select New SQL Server Registration)
2. In the 'Select a SQL Server' page (second page), In the 'Available
Servers' Text box enter the Computer Name on which the MSDE is installed.
(Hope it is a default instance. If it is a Named Instance then enter
Instance Name also eg: Default Instance on Computer Named Test - TEST,
Named Instance 'Test1' on TEST - TEST\Test1 ). Then click 'ADD' button.
Click Next.
3. In the Next Page Select Authentication Mode.
4. In the Next Page Click Next
5. In the Last Page Select Finish.
After few minutes, You would see a screen which should say
'Server Registration completed' Status 'Registered Successfully'.
If this goes through, You would be able to see the MSDE in your Enterprise
manager. In case it fails, Please mail me the exact Error Message that you
would see in the Status column. We would try and troubleshoot it further.
Thanks,
Soma Sekhara Reddy
|||There is no firewall on that server and I'm in the same subnet trying to
connect.
"Ron Allen" <rallen@._nospam_src-us.com> wrote in message
news:eXZzmPJpEHA.1644@.tk2msftngp13.phx.gbl...
> Claus,
> Have you checked the firewall settings on the second server? If it
has[vbcol=seagreen]
> the TCP port used by MSDE blocked you won't be able to connect.
> Ron Allen
> "cjobes" <cjobes@.nova-tech.org> wrote in message
> news:%23WJfzS9oEHA.3460@.tk2msftngp13.phx.gbl...
named[vbcol=seagreen]
on[vbcol=seagreen]
we[vbcol=seagreen]
and[vbcol=seagreen]
one.
>
|||Thanks for your answer. This is what I have tried several times. The answer
I get back is "SQL server not running or access denied". I'm trying to
connect with SQL authentication (sa and password). I'm sure about the sa and
password because I use it in the local ODBC connection and the test works
fine.
I know I'm missing something really obvious - just can't put my finger on
it.
Claus
"Soma Sekhara Reddy" <somsredd@.microsoft.com> wrote in message
news:nyon0IQpEHA.3212@.cpmsftngxa06.phx.gbl...
> Hi Claus,
> I might need more inputs to trouble shoot this issue. Before this, you
> could try Re- registering the MSDE Server in your Enterprise Manager.
> Please use the Register SQL Server Wizard. For the sake of Clarity, I am
> outling the steps here.
> In the Enterprise Manager, If the MSDE Server is already
> Registered, then Select Server, Right Click on the Server and Select
Delete
> SQL Server Registration.
> 1. In the Enterprise Manager, Start Register SQL Server Wizard. (Right
> Click on SQL Server Group, Select New SQL Server Registration)
> 2. In the 'Select a SQL Server' page (second page), In the 'Available
> Servers' Text box enter the Computer Name on which the MSDE is installed.
> (Hope it is a default instance. If it is a Named Instance then enter
> Instance Name also eg: Default Instance on Computer Named Test - TEST,
> Named Instance 'Test1' on TEST - TEST\Test1 ). Then click 'ADD' button.
> Click Next.
> 3. In the Next Page Select Authentication Mode.
> 4. In the Next Page Click Next
> 5. In the Last Page Select Finish.
> After few minutes, You would see a screen which should
say
> 'Server Registration completed' Status 'Registered Successfully'.
> If this goes through, You would be able to see the MSDE in your Enterprise
> manager. In case it fails, Please mail me the exact Error Message that
you
> would see in the Status column. We would try and troubleshoot it further.
> Thanks,
> Soma Sekhara Reddy
>
|||Hi Claus,
Please use the 'ODBCPING' command line utility to check the connectivity.
The syntax is
odbcping -Sservername -Uusername -Ppassword
This tool is loaded with SQL Server client utilities and would be available
on your system. Please do not leave any space betweeb -S and servername,
-S is caps (case sensitive).
Thanks,
Soma Sekhara Reddy

Can't connect via Enterprise Manager

I had a similar problem that was due to the server not
using the proper TCP/IP port. I am guessing that one of
your servers is using a different port, (or none at all),
so it can't be seen by clients looking for the default
port number 1433, at least that was the problem in my case.
Check your Windows registry settings for the following
entries, (this is the key for a default instance, but
there are similar key paths for multiple instances):
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServ
er\SuperSocketNetLib\Tcp\TcpPort
This value is the port that SQL Server will listen on. In
some cases it does not get set up correctly on the
install. The default is a decimal value of "1433" (if it
was blank then the server was only using shared memory
protocol)
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ Client\Su
perSocketNetLib\Tcp\DefaultPort
This value is the port that clients use to communicate
with the server. It normally will also be "1433" (decimal).
If you do change these values you should shut down the
server service first and check the registry again after
the server is running again... I had a heck of a time
getting my server to use port 1433, as it kept switching
to port 2433 after the server started up. (Not sure if
it's necessary, but I also put a "" in the TcpDynamicPorts
variable) to make sure dynamic port assignments is off.
Alternatively, if you do have different port settings and
need to keep them as they are, you can create alias
entries on your clients that will associate the proper
protocols and ports for each server.
HTH,
TK
>--Original Message--
>Hi All,
>We have a MSDE on a W2K server installed. It is running
fine and the
>application can access it without a problem. We have
another server on that
>same subnet that has an SQL 2000 server installed. When
trying to connect to
>the MSDE via the Enterprise Manager, only the local SQL
shows up and we
>cannot connect to the MSDE instance.
>When we go to the ODBC on the MSDE box we see both SQL -
the local and the
>remote one. On the ODBC on the other server we only see
the local one.
>Does anybody have an idea what is going on?
>Thanks,
>Claus
>
>.
>
Thanks for the reply. I finally was able to connect. I still don't have any
idea what the reason was. I rebooted both servers and it worked without
making any changes. No entries in the event logs.
MS never stops surprising me.
thanks again to all of you for your good advise,
Claus
"TK" <anonymous@.discussions.microsoft.com> wrote in message
news:3c9f01c4a58c$61560b90$a301280a@.phx.gbl...[vbcol=seagreen]
> I had a similar problem that was due to the server not
> using the proper TCP/IP port. I am guessing that one of
> your servers is using a different port, (or none at all),
> so it can't be seen by clients looking for the default
> port number 1433, at least that was the problem in my case.
> Check your Windows registry settings for the following
> entries, (this is the key for a default instance, but
> there are similar key paths for multiple instances):
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServ
> er\SuperSocketNetLib\Tcp\TcpPort
> This value is the port that SQL Server will listen on. In
> some cases it does not get set up correctly on the
> install. The default is a decimal value of "1433" (if it
> was blank then the server was only using shared memory
> protocol)
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ Client\Su
> perSocketNetLib\Tcp\DefaultPort
> This value is the port that clients use to communicate
> with the server. It normally will also be "1433" (decimal).
> If you do change these values you should shut down the
> server service first and check the registry again after
> the server is running again... I had a heck of a time
> getting my server to use port 1433, as it kept switching
> to port 2433 after the server started up. (Not sure if
> it's necessary, but I also put a "" in the TcpDynamicPorts
> variable) to make sure dynamic port assignments is off.
> Alternatively, if you do have different port settings and
> need to keep them as they are, you can create alias
> entries on your clients that will associate the proper
> protocols and ports for each server.
> HTH,
> TK
> fine and the
> another server on that
> trying to connect to
> shows up and we
> the local and the
> the local one.

Cant connect via EM after changing sa password?

A client of mine changed his SA password "because it hadn't been changed in a while". :mad: Now nobody can get into Enterprise Manager - opening EM or trying to right-click > Connect on the server yields an error:

A connection could not be established to SERVER1.

Reason: login failed for user 'sa'.

Please verify SQL Server is running and check your SQL Server Registration
properties (by right-clicking on the SERVER1 node) and try again.

Of course, if I right-click on the SERVER1 node, I get the same message.

My client remembers the password he set; I managed to use it to get into Query Analyzer, which I thouhght was weird. But no luck with Enterprise Manager. It's just trying to log in as sa without prompting for a pw.

I already tried running sp_Password in Query Analyzer to change the pw back to what it was. Still can't connect to the SQL Server via Enterprise Manager.

What can I do?Did you edit the sql server registration and change the password there?

EDIT: And while I'm Here

Now nobody can get into Enterprise Manager

SCARY

Sorry Rudy|||Unclear from your post: have you tried editing the connection properties, or are you not able to get to that point?

If it won't even let you right-click on the registration to edit the properties, then try dropping the registration and creating a new one.|||Unless BUILTIN\Administrators local group is removed from SQL Server security, you can logon as a local admin or as a member of that group and easily change the SA password.

Can''t Connect to SQl via Windows NT Network

Help!

I'm writing some VB.net 2005 windows applications which connect to various tables within SQL Server 2005.

If my programs are running from C drive, I have no problems connecting to my database.

but if i run my exe file from a network drive, then the SQL server doesnt recognise the user's pc, and wont allow my program to access any data.

Can anyone help me with this problem?

What is the exact error message you came across?

Can you answer the question according to the following guidance?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=362498&SiteID=1

Good Luck!

Ming.

|||I guess you are receiving exception due to security restrictions, right ? This is caused by the CAS defined for network locations making it not possible to use all applications / assemblies from network ressources.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

The problem was solved by adding a strong name when publishing the program.

cant connect to sql server, error

hi if someone could help, i appreciate: i have windows 2003 server and sql server 2000, i have a few machines connected via odbc and seems to work fine, my problem is when i try to make a new connection via odbc, appears: sql server odbc error: ConnectionOpen and server does not exist or access denied, i try few things, make a ping to the server and i got response, check the users and passwords, the mdac, check that the port 1433 is established in the client network utility, etc, now when i do a telnet to the server the port 1433, appears and error: couldnt connect,i believe this is why i cant make a odbc connection, but i cant figure it out how to make the port listens my petitions., now if itsa supossed to be closed, why the others machines cant connect just fine?

Do you already review the firewall for sql server ports?

http://support.microsoft.com/kb/287932/en

Can't connect to SQL server Northwind database

I am trying to connect to SQL 7.0 northwind database via visual studio
2005. But I can't open the connection. I get an error saying remote
access is not allowed. But the remote access is ok. I can used the same
login and connect to the sql server via enterprise manage.

SqlConnection conn = new SqlConnection("Data
Source=(sqlserver:1433);Initial Catalog=Northwind;User
ID=me;Password=mypassword");

The above is the string I am trying to use.

Is there a way to do this in Visual studio thankspodx (nate.eckstine@.seattle.gov) writes:

Quote:

Originally Posted by

I am trying to connect to SQL 7.0 northwind database via visual studio
2005. But I can't open the connection. I get an error saying remote
access is not allowed. But the remote access is ok. I can used the same
login and connect to the sql server via enterprise manage.
>
SqlConnection conn = new SqlConnection("Data
Source=(sqlserver:1433);Initial Catalog=Northwind;User
ID=me;Password=mypassword");
>
The above is the string I am trying to use.

Is the name of the SQL Server machine realluy "sqlserver"? If SQL
Server is running on your local machine, try "(local)" instead.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Cant connect to SQL 2005 Express with SQL Server Management Studio Express

I've seen the following error posted when people try to connect to their server via their applications but didn't see anyone having problems when trying to connect with SQL Server Management Studio Express. Am I missing something here? This is the error:

<<
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)(Microsoft SQL Server, Error: 2)
>
The server is not remote so I don't see why I need to enable remote connection. I am also using the default connection settings.

Are U using 'Windows Authentication' or SQL Server Auth?

While trying to login as 'sa' on my SQLServ2005 Express, I'm getting a bunch of errors like...

Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)

No idea why !!!

I thought 'sa' was the ultimate super-user login. If 'sa' is not a trusted connection, then who is... sounds like a big joke !!

|||

I figured out the solution to my problem. By default, the Server Managaement Studio tried to connect to my computer name. It turns out when you install SQL 2000 Express, the default instance name is SQLEXPRESS. So when connecting, I just changed the server name to <computer name>\SQLEXPRESS and it worked!

As to your problem BugSlayer, I have seen that error before. It was due to the fact that the server was configured to allow only windows authentication. It has to be set to "mixed authentication" or "both windows and sql authentication" (I forget what the exact words were). I tried to look for the setting but couldn't find it. I set mine explicitly during installation. Hope that helps.

|||

Thanks NthPixel.

Actually my installation of SQL 2005 Express was an accident waiting to happen. I had installed on top of an existing MSDE (from VS 7.0) and for reasons unknown the 'sa' account was locked out PLUS built-in/Administrators did not have any grant rights. A classic catch-22 situation !!

Had to uninstall both SQLExpr & MSDE and reinstall SQLExpr with mixed auth mode this time, and now I'm able to use both types of authentications. Although our symptons match, the problem on my machine basically arised from upgrading MSDE to SQLServer 2005 Express.

If any of U have such a setup, please remove and simplify it before it blows up in to a massive disaster at some future critical juncture.

Can't Connect to SQL 2005 Express Edition via Server Manangment Studio

I have installed SQL 2005 Express Edition on a Windows 2003 Web Edition server. Everything installed correctly, no errors to be found. I also have:

Local & Remote Connections using TCP/IP only turne don

SQL Browser is running as well.

I have tried connecting with the most recent CTP of Microsoft SQL Server Management Studio Express 9.00.1399.00

When trying to connect using the SA account I recieve:

'An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (Provider: Named Pipes Provider, error 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

After that failed I tried creating a connection locally on the server using ODBC Manager with no luck as well.

Microsoft SQL Native Client Version 09.00.1399

Running connectivity tests...

Attempting connection
[Microsoft][SQL Native Client]TCP Provider: No connection could be made because the target machine actively refused it.

[Microsoft][SQL Native Client]Login timeout expired
[Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

TESTS FAILED!

Any help would be appreciated.

Try this.

Start > All Programs > Microsoft SQL Server 2005 > Configuration tools > SQL Server Surface Area Configuration

Then click Surface Area Configuration for Services and Connection. Select your instance of sql server (by default MSSQLSERVER). Then expand Database Engine and click on remote connections. On the right side select Local and remote connections > Using both TCO/IP and named pipes.

|||

I'm having the same issue, i've tried all of the above. My server has 9 active IP addresses, and I've tried connecting to the one which I use to remote in to the server. Is this the correct approach?

Also, in the SQL Server Configuration Manager, I've set that IP address to 'Active' and 'Enabled' with no luck. Same error as the gentleman above.

Any other suggestions?

Thank you,

Bret

|||I still can't get it to work. I've even tried the old remove and reinstall approach. This is very aggravating as I've tried everything under the sun that I can think of.|||

Got it working:

Under Protocols for SQLEXPRESS and tcp/ip and the ip addresses tab

Tcp dynamic ports – set to blank

Disabled other ips except the loopback

At the bottom, set dynamic ports to blank and the tcp port to 1433

Stopped and restarted the sql server.

Can't Connect to SQL 2005 Express Edition via Server Manangment Studio

I have installed SQL 2005 Express Edition on a Windows 2003 Web Edition server. Everything installed correctly, no errors to be found. I also have:

Local & Remote Connections using TCP/IP only turne don

SQL Browser is running as well.

I have tried connecting with the most recent CTP of Microsoft SQL Server Management Studio Express 9.00.1399.00

When trying to connect using the SA account I recieve:

'An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (Provider: Named Pipes Provider, error 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

After that failed I tried creating a connection locally on the server using ODBC Manager with no luck as well.

Microsoft SQL Native Client Version 09.00.1399

Running connectivity tests...

Attempting connection
[Microsoft][SQL Native Client]TCP Provider: No connection could be made because the target machine actively refused it.

[Microsoft][SQL Native Client]Login timeout expired
[Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

TESTS FAILED!

Any help would be appreciated.

Try this.

Start > All Programs > Microsoft SQL Server 2005 > Configuration tools > SQL Server Surface Area Configuration

Then click Surface Area Configuration for Services and Connection. Select your instance of sql server (by default MSSQLSERVER). Then expand Database Engine and click on remote connections. On the right side select Local and remote connections > Using both TCO/IP and named pipes.

|||

I'm having the same issue, i've tried all of the above. My server has 9 active IP addresses, and I've tried connecting to the one which I use to remote in to the server. Is this the correct approach?

Also, in the SQL Server Configuration Manager, I've set that IP address to 'Active' and 'Enabled' with no luck. Same error as the gentleman above.

Any other suggestions?

Thank you,

Bret

|||I still can't get it to work. I've even tried the old remove and reinstall approach. This is very aggravating as I've tried everything under the sun that I can think of.|||

Got it working:

Under Protocols for SQLEXPRESS and tcp/ip and the ip addresses tab

Tcp dynamic ports – set to blank

Disabled other ips except the loopback

At the bottom, set dynamic ports to blank and the tcp port to 1433

Stopped and restarted the sql server.