Big problem connecting SQLEXPRESS within a vb net application

Hello.
I've an application that has to do a bunch of "SELECT" and INSERT into a
couple of tables. On my machine everything works fine, but if I try to
deploy the app on a VM for a test i have many probs.
The most common is "(Named Pipes Provider, error: 40 - Could not open a
connection to SQL
Server)", but using (local)\SQLEXPRESS i've "Request for the permission of
type
'System.Data.SqlClient.SqlClientPermission, System.Data, version=2.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e89'" too...I think it's a
connectionstring problem. I used "Data Source=(local)\SQLEXPRESS;Initial
Catalog=Clienti;Integrated
Security=True", where "Clienti" is the DB, but i tried the string I found on
http://www.connectionstrings.com/?carrier=sqlserver2005 too.
It's being absurd...please give me an help...thanks...Ah, did you enable TCP/IP on the target server? Why are you using named
pipes? If you do, you must enable additional ports in the firewall (if there
is one).
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"THE JOK3R" <a@.a.a> wrote in message
news:%23GL$eDNjHHA.4520@.TK2MSFTNGP02.phx.gbl...
> Hello.
> I've an application that has to do a bunch of "SELECT" and INSERT into a
> couple of tables. On my machine everything works fine, but if I try to
> deploy the app on a VM for a test i have many probs.
> The most common is "(Named Pipes Provider, error: 40 - Could not open a
> connection to SQL
> Server)", but using (local)\SQLEXPRESS i've "Request for the permission of
> type
> 'System.Data.SqlClient.SqlClientPermission, System.Data, version=2.0.0.0,
> Culture=neutral, PublicKeyToken=b77a5c561934e89'" too...I think it's a
> connectionstring problem. I used "Data Source=(local)\SQLEXPRESS;Initial
> Catalog=Clienti;Integrated
> Security=True", where "Clienti" is the DB, but i tried the string I found
> on http://www.connectionstrings.com/?carrier=sqlserver2005 too.
> It's being absurd...please give me an help...thanks...|||"William (Bill) Vaughn" <billvaRemoveThis@.betav.com> wrote in message
news:OpGW39NjHHA.1624@.TK2MSFTNGP06.phx.gbl...
> Ah, did you enable TCP/IP on the target server? Why are you using named
> pipes? If you do, you must enable additional ports in the firewall (if
> there is one).
I both did everything...enabled TCP/IP and Remote Connection, opened port
1431 default port...|||I suggest you walk through the list of issues posted in my blog--there is a
whitepaper there that discusses these
issues.http://betav.com/blog/billva/2006/0...com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"THE JOK3R" <a@.a.a> wrote in message
news:O8v9ZKOjHHA.4936@.TK2MSFTNGP03.phx.gbl...
>
> "William (Bill) Vaughn" <billvaRemoveThis@.betav.com> wrote in message
> news:OpGW39NjHHA.1624@.TK2MSFTNGP06.phx.gbl...
> I both did everything...enabled TCP/IP and Remote Connection, opened port
> 1431 default port...

Big problem connecting SQLEXPRESS within a vb net application

Hello.
I've an application that has to do a bunch of "SELECT" and INSERT into a
couple of tables. On my machine everything works fine, but if I try to
deploy the app on a VM for a test i have many probs.
The most common is "(Named Pipes Provider, error: 40 - Could not open a
connection to SQL
Server)", but using (local)\SQLEXPRESS i've "Request for the permission of
type
'System.Data.SqlClient.SqlClientPermission, System.Data, version=2.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e89'" too...I think it's a
connectionstring problem. I used "Data Source=(local)\SQLEXPRESS;Initial
Catalog=Clienti;Integrated
Security=True", where "Clienti" is the DB, but i tried the string I found on
http://www.connectionstrings.com/?carrier=sqlserver2005 too.
It's being absurd...please give me an help...thanks...
Ah, did you enable TCP/IP on the target server? Why are you using named
pipes? If you do, you must enable additional ports in the firewall (if there
is one).
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"THE JOK3R" <a@.a.a> wrote in message
news:%23GL$eDNjHHA.4520@.TK2MSFTNGP02.phx.gbl...
> Hello.
> I've an application that has to do a bunch of "SELECT" and INSERT into a
> couple of tables. On my machine everything works fine, but if I try to
> deploy the app on a VM for a test i have many probs.
> The most common is "(Named Pipes Provider, error: 40 - Could not open a
> connection to SQL
> Server)", but using (local)\SQLEXPRESS i've "Request for the permission of
> type
> 'System.Data.SqlClient.SqlClientPermission, System.Data, version=2.0.0.0,
> Culture=neutral, PublicKeyToken=b77a5c561934e89'" too...I think it's a
> connectionstring problem. I used "Data Source=(local)\SQLEXPRESS;Initial
> Catalog=Clienti;Integrated
> Security=True", where "Clienti" is the DB, but i tried the string I found
> on http://www.connectionstrings.com/?carrier=sqlserver2005 too.
> It's being absurd...please give me an help...thanks...
|||"William (Bill) Vaughn" <billvaRemoveThis@.betav.com> wrote in message
news:OpGW39NjHHA.1624@.TK2MSFTNGP06.phx.gbl...
> Ah, did you enable TCP/IP on the target server? Why are you using named
> pipes? If you do, you must enable additional ports in the firewall (if
> there is one).
I both did everything...enabled TCP/IP and Remote Connection, opened port
1431 default port...
sql

BIDS problem

I just installed the RTM of the standard version of SQL Server 2005 Client Tools on a Windows XP machine.

When I initially opened the SQL Server Business Intelligence Development Studio, I received about 6 pop-up messages saying that it couldn't load a package (I didn't copy the message and can't get it to repeat now).

When I try to create an Analysis Services package, I now get the message:
"Could not load type 'Microsoft.VisualStudio.Shell.Interop.IVsHasRelatedSaveItems' from assembly 'Microsoft.VisualStudio.Shell.Interop.8.0, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

I believe this is some sort of setup issue, but am not sure how to troubleshoot or fix this.

Thanks for your help,
Jessica

I'm getting the exact same error when I try to create a new report. Any luck in figuring it out?

|||FYI - I found the solution in case you are still looking. Go here http://forums.microsoft.com/msdn/showpost.aspx?postid=2098&siteid=1|||Thanks Mike! That did the trick :-D

BIDS problem

I just installed the RTM of the standard version of SQL Server 2005 Client Tools on a Windows XP machine.

When I initially opened the SQL Server Business Intelligence Development Studio, I received about 6 pop-up messages saying that it couldn't load a package (I didn't copy the message and can't get it to repeat now).

When I try to create an Analysis Services package, I now get the message:
"Could not load type 'Microsoft.VisualStudio.Shell.Interop.IVsHasRelatedSaveItems' from assembly 'Microsoft.VisualStudio.Shell.Interop.8.0, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

I believe this is some sort of setup issue, but am not sure how to troubleshoot or fix this.

Thanks for your help,
Jessica

I'm getting the exact same error when I try to create a new report. Any luck in figuring it out?

|||FYI - I found the solution in case you are still looking. Go here http://forums.microsoft.com/msdn/showpost.aspx?postid=2098&siteid=1|||Thanks Mike! That did the trick :-D

BIDS (VS 2005 Professional) Hangs

Occasionally, when I try to edit a package I get an error. Visual studio is busyfound VS hanged.

It is specific to my machine or a common problem.

You are not the only person. For me, VS usually hangs for only a minute or so.

|||I hope it will be corrected in 2008 version.

BIDS (VS 2005 Professional) Hangs

Occasionally, when I try to edit a package I get an error. Visual studio is busyfound VS hanged.

It is specific to my machine or a common problem.

You are not the only person. For me, VS usually hangs for only a minute or so.

|||I hope it will be corrected in 2008 version.

Bidirectional transactional replication and remote distributors

I want to be able to setup the following configuration using bidirectional transactional replication on SQL 2005

instance A lives on machine 1

instance B lives on machine 2

Instance A publishes to a transactional subscription on Instance B

Instance B does the reverse and publishes to a transactional subscription on Instance A

Instance A pushes to a distribution database on machine 2

Instance B pushes to a distribution database on machine 1

Problems Implementing Configuration

I can setup each instance as a distributor and create separate distribution databases using

sp_adddistributor and sp_adddistributiondb

I can then enable each publisher to use the correct distribution database using sp_adddistpublisher

However, when I try and run sp_replicationdboption to setup a database for publication, I get the error:

Msg 20028, Level 16, State 1, Procedure sp_MSpublishdb, Line 55

The Distributor has not been installed correctly. Could not enable database for publishing.

If I try and configure a publication with the wizard, it says that instance A must be enabled as a publisher before you can create a publication - and then presents the dialog to add instance A to be handled by the local distribution database - which I don't want.

It appears that I need to run sp_adddistributor on the publisher as well as the distributor for the appropriate instance, but if I do this I get the error:

Msg 14099, Level 16, State 1, Procedure sp_adddistributor, Line 109

The server 'instance A' is already defined as a Distributor.

It seems that you can't select a remote distributor if you already have a local distributor configured.

Is there a way round this limitation?

Note that configuring the environment with a single distribution database works fine

Try calling sp_adddistpublisher on machine 1 to add machine 2 as publisher and do the same on machine 2 to add machine 1 as publisher.

Regards,

Gary

|||Check out the new Peer-Peer replication in 2005 which does exactly what you want.|||

Gary - I have tried what you suggested and got the following error as per my original post

Msg 14099, Level 16, State 1, Procedure sp_adddistributor, Line 109

The server 'instance A' is already defined as a Distributor.

=====================

Dinakar - thanks for the suggestion - I have been checking out peer to peer, but I am not sure if I can live with the restrictions

=====================

I will probably go with a single distribution database located on the publisher with the lowest load. This should be satisfactory for the requirements

Thanks

aero1

BI studio

hi,

I have to connect to use a cube that is residing on different machine in order to develop a mining structure using MS associations rules algorithm.

Can anybody tell me the connection type (for Data Source) I should use so that I can use the same to create Data Source View OR Mining Structure?

I tried using OLAP, Analysis Service 9.0, OLAP 8.0, Data Mining - connection types. I could see only data source created using Data Mining connection while i was creating data source view.

Please help me as to which method I should use to connect cube on remote server to create a mining structure.

Thank you.

Aashutosh

SQL Server Data Mining does not allow you to create mining structure on cubes residing on remote servers or in another database on the same server - the source cube for an OLAP mining structure needs to be in the same database as the mining structure.

|||The only option would be to use DMX statements to create and train a mining structure (CREATE MINING STRUCTURE and INSERT INTO statements)|||

Hi,

thank you for your help.

I will try using DMX. One more question:

If I connect to remote server (which has the cube) using SQL server Management Studio to create a mining structure, will it modify the database on the remote server?

Aashutosh

|||

Creating a mining structure on the remote server is modifying the database as you are creating an object.

If you don't want to permanently change the database, you can use CREATE SESSION MINING STRUCTURE.... but you first have to enable session objects on that server (available in server properties).

If you are creating a mining structure on a server and populating from another analysis services database through OPENQUERY, then you do not modify the source database.

|||

Thank you for your help.

Will the same thing happen in case of relational database, i.e.

If I use relational database on remote server and create mining structure using BI development studio installed on local machine, will it modify the database on the remote server?

thank you once again.

Aashutosh Magdum

BI studio

hi,

I have to connect to use a cube that is residing on different machine in order to develop a mining structure using MS associations rules algorithm.

Can anybody tell me the connection type (for Data Source) I should use so that I can use the same to create Data Source View OR Mining Structure?

I tried using OLAP, Analysis Service 9.0, OLAP 8.0, Data Mining - connection types. I could see only data source created using Data Mining connection while i was creating data source view.

Please help me as to which method I should use to connect cube on remote server to create a mining structure.

Thank you.

Aashutosh

SQL Server Data Mining does not allow you to create mining structure on cubes residing on remote servers or in another database on the same server - the source cube for an OLAP mining structure needs to be in the same database as the mining structure.

|||The only option would be to use DMX statements to create and train a mining structure (CREATE MINING STRUCTURE and INSERT INTO statements)|||

Hi,

thank you for your help.

I will try using DMX. One more question:

If I connect to remote server (which has the cube) using SQL server Management Studio to create a mining structure, will it modify the database on the remote server?

Aashutosh

|||

Creating a mining structure on the remote server is modifying the database as you are creating an object.

If you don't want to permanently change the database, you can use CREATE SESSION MINING STRUCTURE.... but you first have to enable session objects on that server (available in server properties).

If you are creating a mining structure on a server and populating from another analysis services database through OPENQUERY, then you do not modify the source database.

|||

Thank you for your help.

Will the same thing happen in case of relational database, i.e.

If I use relational database on remote server and create mining structure using BI development studio installed on local machine, will it modify the database on the remote server?

thank you once again.

Aashutosh Magdum

BI Portal 2003 on a 64 Bit Machine

Hello Everyone,

Has anyoen tried to use BI Portal on a 64 bit machine with a 64 bit SQL Server? Any problems?

Thanks,

Joseph

Not sure what product you refer to. This forum is about to SQL Server Analysis Services related issues.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

BI Portal is microsoft's addition to sharepoint (web parts) in able to create pages that connect directly to Analysis Services cubes. We've used it before on a 32 bit server connecting to Analysis Server 2005.

I was just wondering if anyone has tried to use BI Portal on a 64 bit machine to connect to a 64 bit Analysis Server of SQL 2005.

BI Dev Studio won't install with June CTP reinstallation

I am attempting to install the BI Development Studio, from the SQL Server 2005 June CTP, on an XP machine. It installed successfully the first time I installed it, along with all other Workstation Components and BOL.

Subsequently I have uninstalled and reinstalled the Workstation Components, but the installation process does not fully install BI Development Studio. It creates the C:\Program Files\Microsoft Visual Studio 8\Common7\IDE directory (where devenv.exe should be located), but this directory is empty other than the PrivateAssemblies and profiles subdirectories. After an installation , the Start Programs menu contains an option for “SQL Server Business Intelligence Development Studio” under "MS SQL Server 2005 CTP", but this shortcut points to the non-existent C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\devenv.exe

There are no installation errors, and everything else seems to install OK, but BI Dev Studio is simply not there..

I have used both Add/Remove Programs, and the Build Uninstall Wizard, to remove the installation before trying the reinstalls.

This machine also has Visual Studio 2003 and a SQL Server 2000 instance, but they were already in place prior to my first successful installation.

Thanks in advance!

This is not a very satisfying answer, but here's how we fixed it.

After running the Build Uninstall Wizard once again, we manually removed all folders and all files throughout the hard drive related to SQL Server 2005 (i.e. 9) and Visual Studio 2005 (i.e. 8). Also all registry entries. After manually removing all of this, the installation worked successfully.

Bottom line: the Build Uninstall Wizard fails to remove quite a few files and registry settings on your machine, some of which prevented the successful reinstall of the BI Dev Studio.

Beyond 8 GB memory

We upgraded our server to Windows 2003 Ent edition and added extra 8 GB memory to the machine, operating system sees all 16 GB also ent mgr properties shows all 16 GB memory, I assigned 14 GB to SQL server but perf monitor (total server memory) only shows 7GB memory, any reason for this?Did you restart your SQL Service?
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Sam Moayedi" <anonymous@.discussions.microsoft.com> wrote in message
news:CF7CA24D-D1FD-4C6F-A891-F9BBE6559DAC@.microsoft.com...
> We upgraded our server to Windows 2003 Ent edition and added extra 8 GB
memory to the machine, operating system sees all 16 GB also ent mgr
properties shows all 16 GB memory, I assigned 14 GB to SQL server but perf
monitor (total server memory) only shows 7GB memory, any reason for this?

Beware installing SQL Server 2005 BOL (May 2007)

Beware installing this update, it can seriously damage your health. I clicked 'install' on my Vista 64 machine and let it trundle off to itself while I was doing some Visual Studio work. It runs for a while and then ... RESTARTs my PC. Without asking and withoug allowing me to save my work. Fresh, new work, gone. Thanks a bunch guys, installing some new docs really merits a restart.

This event is in the system log:

The process msiexec.exe has initiated the restart of computer BLUE on behalf of user NT AUTHORITY\SYSTEM for the following reason: No title for this reason could be found

Reason Code: 0x80030002

Shutdown Type: restart

Comment: The Windows Installer initiated a system restart to complete or continue the configuration of 'Microsoft SQL Server 2005 Books Online (English) (May 2007)'.

Thanks very much for bringing this issue to our attention. It is sometimes necessary to reboot after a Books Online update - because Books Online, Visual Studio, and SQL Server Management Studio share components - but the expected behavior is a prompt for reboot rather than an automatic reboot. We are actively investigating the issue, and will re-release the update after we identify a solution, so that other customers will not have a similar experience.

|||

Bryan

Thank you far replying to my post -- I am a bit calmer now I have had about four reboots (on various machines) in the last week because of SQL Server patches and I was a bit fractious.

Beware installing SQL Server 2005 BOL (May 2007)

Beware installing this update, it can seriously damage your health. I clicked 'install' on my Vista 64 machine and let it trundle off to itself while I was doing some Visual Studio work. It runs for a while and then ... RESTARTs my PC. Without asking and withoug allowing me to save my work. Fresh, new work, gone. Thanks a bunch guys, installing some new docs really merits a restart.

This event is in the system log:

The process msiexec.exe has initiated the restart of computer BLUE on behalf of user NT AUTHORITY\SYSTEM for the following reason: No title for this reason could be found

Reason Code: 0x80030002

Shutdown Type: restart

Comment: The Windows Installer initiated a system restart to complete or continue the configuration of 'Microsoft SQL Server 2005 Books Online (English) (May 2007)'.

Thanks very much for bringing this issue to our attention. It is sometimes necessary to reboot after a Books Online update - because Books Online, Visual Studio, and SQL Server Management Studio share components - but the expected behavior is a prompt for reboot rather than an automatic reboot. We are actively investigating the issue, and will re-release the update after we identify a solution, so that other customers will not have a similar experience.

|||

Bryan

Thank you far replying to my post -- I am a bit calmer now I have had about four reboots (on various machines) in the last week because of SQL Server patches and I was a bit fractious.