Data diiferentator tools

Hi All,
We have a kiosk application which will be distributed across the states
and connected to network on a cellular broadband connection. Kiosks
transmit records to our central server on a periodic basis.
We use a 3rd party vendor database in kiosks which needs to be updated
once a month. Vendor is not ready to give us a differential database so
we have to write our own utility to do this.
Are there any 3rd party tools available to this or any other
suggestions will be greatly appreciated.
Regards,
SobhanRed-Gate SQL Data Compare (www.red-gate.com)
Amos.
<Sobhan.Vezzu@.gmail.com> wrote in message
news:1150928122.648282.308070@.p79g2000cwp.googlegroups.com...
> Hi All,
> We have a kiosk application which will be distributed across the states
> and connected to network on a cellular broadband connection. Kiosks
> transmit records to our central server on a periodic basis.
> We use a 3rd party vendor database in kiosks which needs to be updated
> once a month. Vendor is not ready to give us a differential database so
> we have to write our own utility to do this.
> Are there any 3rd party tools available to this or any other
> suggestions will be greatly appreciated.
> Regards,
> Sobhan
>|||Red-Gate SQL Data Compare (www.red-gate.com)
Amos.
<Sobhan.Vezzu@.gmail.com> wrote in message
news:1150928122.648282.308070@.p79g2000cwp.googlegroups.com...
> Hi All,
> We have a kiosk application which will be distributed across the states
> and connected to network on a cellular broadband connection. Kiosks
> transmit records to our central server on a periodic basis.
> We use a 3rd party vendor database in kiosks which needs to be updated
> once a month. Vendor is not ready to give us a differential database so
> we have to write our own utility to do this.
> Are there any 3rd party tools available to this or any other
> suggestions will be greatly appreciated.
> Regards,
> Sobhan
>

Data diiferentator tools

Hi All,
We have a kiosk application which will be distributed across the states
and connected to network on a cellular broadband connection. Kiosks
transmit records to our central server on a periodic basis.
We use a 3rd party vendor database in kiosks which needs to be updated
once a month. Vendor is not ready to give us a differential database so
we have to write our own utility to do this.
Are there any 3rd party tools available to this or any other
suggestions will be greatly appreciated.
Regards,
SobhanRed-Gate SQL Data Compare (www.red-gate.com)
Amos.
<Sobhan.Vezzu@.gmail.com> wrote in message
news:1150928122.648282.308070@.p79g2000cwp.googlegroups.com...
> Hi All,
> We have a kiosk application which will be distributed across the states
> and connected to network on a cellular broadband connection. Kiosks
> transmit records to our central server on a periodic basis.
> We use a 3rd party vendor database in kiosks which needs to be updated
> once a month. Vendor is not ready to give us a differential database so
> we have to write our own utility to do this.
> Are there any 3rd party tools available to this or any other
> suggestions will be greatly appreciated.
> Regards,
> Sobhan
>

Data Connections: Where the hell are they stored?!!

Hello all,

Does anybody know where SSIS Data Connections are stored? Whenever one creates a Connection Manager, a list of all created Data Connections appears. It's very quick and easy to create a Connection Manager from an existing Data Connection, so really the latter are in essence the Connection Managers and are thus part of the application. It is therefore important to back them up if for example one wants to migrate the application to another computer. I have looked everywhere in Documents and Settings and Program Files and I can't find any folder or file where these Data Connections are stored! It's annoying to have this mysterious black-box behaviour!

Does anybody know?

Thanks in advance,

Jerome Smith

The data connections list is stored in the registry under HKCU\Software\Microsoft\VisualStudio\8.0\Packages\{4A0C6509-BF90-43DA-ABEE-0ABA3A8527F1}\Settings\Data\Connections. Its a BIDS specific setting, not specific to SSIS, but nevertheless used for GUI based package development under BIDS.

If one were to migrate to a different machine for package development, I could see where it would be useful to copy those registry entries over, true enough, in the same sense that you can export/import favorites from IE, or server listings from management studio.

One note though, the data connections are a measure of convenience (a memory bank of previous connections) to individuals, and are not a deployment/migration artifact. Connection managers are persisted in the IS packages (which you probably already knew), and when migrated to different environments, configurations are used to mesh IS packages into the new environment.

|||

Hi,

Thanks for your reply.

Forgive my ignorance, but what is BIDS?

Now OK, connection managers are persisted in the IS packages, but what use are they if they don't store connection information (Server, Authentication, Database)? I thought that's what they were for but it now appears that this connection information is stored in the Windows registry, which is not persisted in the IS packages.

Is there any way to retain the connection information in the connection managers?

Cheers,

Jerome

|||

Connection managers do store connection information.

You thought that's what they were for and that is exactly correct.

Now the confusing part is that the connection information is stored in "both" places.

However, once the connection manager is made, that information has been copied into the package itself, and that registry entry might as well have never existed and does not need to exist in the future.

Now, if you want to see the last point demonstrated rather than just asserted (that is, that a connection manager's connectivity information is persisted to the package), create a IS package in BIDS with an OLEDB connection manager used in an execute sql task and execute the package sucessfully from BIDS.

Then,export those those registry entries and delete them (you'll reimport them later), using a tool like regedit.exe.

If you don't want to to mess with the registry, the following will demonstrate the point as well; double-click on the connection manager and point it to a different database.

Now, run the package . What happens? Runs as before. Which database is hit? The one the connection manager was changed too. Is the registry updated to point to the connection manager's current database? No, it is not.

The connection information is persisted to the package.

Now, if you deleted the registry entries, re-import them.

BIDS is an acryonym for Business Intelligence development studio, which is the design-time environment hosted by Visual Studio 2005 for building BI projects ( Integration Services, Analysis Services, Reporting Services).

|||

Thank you very much. That was very useful.

Best regards,

Jerome Smith

Data Connections: Where the hell are they stored?!!

Hello all,

Does anybody know where SSIS Data Connections are stored? Whenever one creates a Connection Manager, a list of all created Data Connections appears. It's very quick and easy to create a Connection Manager from an existing Data Connection, so really the latter are in essence the Connection Managers and are thus part of the application. It is therefore important to back them up if for example one wants to migrate the application to another computer. I have looked everywhere in Documents and Settings and Program Files and I can't find any folder or file where these Data Connections are stored! It's annoying to have this mysterious black-box behaviour!

Does anybody know?

Thanks in advance,

Jerome Smith

The data connections list is stored in the registry under HKCU\Software\Microsoft\VisualStudio\8.0\Packages\{4A0C6509-BF90-43DA-ABEE-0ABA3A8527F1}\Settings\Data\Connections. Its a BIDS specific setting, not specific to SSIS, but nevertheless used for GUI based package development under BIDS.

If one were to migrate to a different machine for package development, I could see where it would be useful to copy those registry entries over, true enough, in the same sense that you can export/import favorites from IE, or server listings from management studio.

One note though, the data connections are a measure of convenience (a memory bank of previous connections) to individuals, and are not a deployment/migration artifact. Connection managers are persisted in the IS packages (which you probably already knew), and when migrated to different environments, configurations are used to mesh IS packages into the new environment.

|||

Hi,

Thanks for your reply.

Forgive my ignorance, but what is BIDS?

Now OK, connection managers are persisted in the IS packages, but what use are they if they don't store connection information (Server, Authentication, Database)? I thought that's what they were for but it now appears that this connection information is stored in the Windows registry, which is not persisted in the IS packages.

Is there any way to retain the connection information in the connection managers?

Cheers,

Jerome

|||

Connection managers do store connection information.

You thought that's what they were for and that is exactly correct.

Now the confusing part is that the connection information is stored in "both" places.

However, once the connection manager is made, that information has been copied into the package itself, and that registry entry might as well have never existed and does not need to exist in the future.

Now, if you want to see the last point demonstrated rather than just asserted (that is, that a connection manager's connectivity information is persisted to the package), create a IS package in BIDS with an OLEDB connection manager used in an execute sql task and execute the package sucessfully from BIDS.

Then,export those those registry entries and delete them (you'll reimport them later), using a tool like regedit.exe.

If you don't want to to mess with the registry, the following will demonstrate the point as well; double-click on the connection manager and point it to a different database.

Now, run the package . What happens? Runs as before. Which database is hit? The one the connection manager was changed too. Is the registry updated to point to the connection manager's current database? No, it is not.

The connection information is persisted to the package.

Now, if you deleted the registry entries, re-import them.

BIDS is an acryonym for Business Intelligence development studio, which is the design-time environment hosted by Visual Studio 2005 for building BI projects ( Integration Services, Analysis Services, Reporting Services).

|||

Thank you very much. That was very useful.

Best regards,

Jerome Smith

Data Connection to SQL Server 2000 using C#

I have asp code that uses C# to create a SQL connection and a command. Then I create a data set and fill the data set using my comand. Finally I bind my data set to a data grid named myDataGrid. I am not sure where myDataGrid comes from since it is never defined. Where does myDataGrid come from? Also, I believe that I do not need to call page_Load since auto wire is set to true by default so it is my understanding that this method page_Load will be called by default.
void page_load(object sender, EventArgs e)
{
SqlConnection myConnection = new SqlConnection("server='(local)'; trusted_connection=true; database='mattsDEMO'"); SqlDataAdapter myCommand = new SqlDataAdapter("select * from people", myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds, "people");
MyDataGrid.DataSource=ds.Tables["people"].DefaultView;
MyDataGrid.DataBind();
}

When I place a data grid controll on my page named myDataGrid, I do not see a data grid and there is no data either. The code in the HTML looks like this:

<body>
<form runat="server">
<p>
<asp:DataGrid id="myDataGrid" runat="server" BorderColor="Maroon"></asp:DataGrid>
</p>
</form>
</body>
I tried using debug that comes with the .Net framework (since I am using Web Matrix) but I get an error saying no symbols were found for this document when setting break points. What are symbols and why do I need them?
So, I basically have four (4) important questions that I need help answering:
1) Why do I not have any data in my data grid?
2) Where did myDataGrid come from?
3) Is the page_Load method called by default if auto wire is set to true or not declared?
4) Why do I need symbols for debug?
Below is all my code in one complete view:
<%@. Page Language="C#" %>
<%@. Register TagPrefix="wmx" Namespace="Microsoft.Matrix.Framework.Web.UI" Assembly="Microsoft.Matrix.Framework, Version=0.6.0.0, Culture=neutral, PublicKeyToken=6f763c9966660626" %>
<%@. import Namespace="System.Data" %>
<%@. import Namespace="System.Data.SqlClient" %>
<script runat="server">

// Insert page code here
//

</script>
<html>
<head>
<script language="C#">
void page_load(object sender, EventArgs e)
{
SqlConnection myConnection = new SqlConnection("server='(local)'; trusted_connection=true; database='mattsDEMO'");
SqlDataAdapter myCommand = new SqlDataAdapter("select * from people", myConnection);

DataSet ds = new DataSet();
myCommand.Fill(ds, "people");

MyDataGrid.DataSource=ds.Tables["people"].DefaultView;
MyDataGrid.DataBind();
}

</script>
</head>
<body>
<form runat="server">
<p>

</p>
<p>
<asp:Label id="Label1" runat="server">This is a test!</asp:Label>
</p>
<p>
<asp:DataGrid id="myDataGrid" runat="server" BorderColor="Maroon"></asp:DataGrid>
</p>
</form>
</body>
</html>
Thanks,
Ryan

(1) you could put a if not ispostback condition in your page_load.
(2) You could set the autogeneratecolumns property of the datagrid to true. I am not good at C#. So I wouldnt try writing code for you.

data connection to fox pro file

Hi,
I have to connect to a foxpro file. What I've attempted thus far is set up a
System DSN. It's pathed to the .dbf file, and I selected the Free Table
Directory option under Database Type. In RS, I choose ODBC driver for my
Provider and for Connection, I choose the DSN I set up. When I try to choose
the Initial catalog, I get an error. The first says The Parameter is
Incorrect and the second says Login failed. Catalog Info cannot be retrieved.
Any suggestions?
Thanks!Try specifying NT user credentials in report data source (or in Report
Manager/Report properties/Datasources if report is already published)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"clutch" <clutch@.discussions.microsoft.com> wrote in message
news:3BDA72CF-9772-4459-9B2C-BDB7F7A850D7@.microsoft.com...
> Hi,
> I have to connect to a foxpro file. What I've attempted thus far is set up
a
> System DSN. It's pathed to the .dbf file, and I selected the Free Table
> Directory option under Database Type. In RS, I choose ODBC driver for my
> Provider and for Connection, I choose the DSN I set up. When I try to
choose
> the Initial catalog, I get an error. The first says The Parameter is
> Incorrect and the second says Login failed. Catalog Info cannot be
retrieved.
> Any suggestions?
> Thanks!|||Hi Clutch,
Try with leaving the Catalog, UserName and Password blank.
Have you considered using the FoxPro and Visual FoxPro OLE DB data provider?
It's downloadable from msdn.microsoft.com/downloads/updates .
--
Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP
cindy_winegarden@.msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
"clutch" <clutch@.discussions.microsoft.com> wrote in message
news:3BDA72CF-9772-4459-9B2C-BDB7F7A850D7@.microsoft.com...
> Hi,
> I have to connect to a foxpro file. What I've attempted thus far is set up
> a
> System DSN. It's pathed to the .dbf file, and I selected the Free Table
> Directory option under Database Type. In RS, I choose ODBC driver for my
> Provider and for Connection, I choose the DSN I set up. When I try to
> choose
> the Initial catalog, I get an error. The first says The Parameter is
> Incorrect and the second says Login failed. Catalog Info cannot be
> retrieved.
> Any suggestions?
> Thanks!

Data Connection problems - Database not found

I resently purchased a Virtual Windows 2003 Standard Server and I installed
SQL 2000 with Service Pack 3 on it to make sure it was up to date. I can ftp
on this server and everthing but when it comes to making a Microsoft ODBC
connection from my local computer to the virtual server I am not able to hook
up with it I recive a server time out is there something someone can be
patience with me and help me with this problem.
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
Can u connect using query analyser.?
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:%23w2amiThEHA.1156@.TK2MSFTNGP10.phx.gbl...
> I resently purchased a Virtual Windows 2003 Standard Server and I
installed
> SQL 2000 with Service Pack 3 on it to make sure it was up to date. I can
ftp
> on this server and everthing but when it comes to making a Microsoft ODBC
> connection from my local computer to the virtual server I am not able to
hook
> up with it I recive a server time out is there something someone can be
> patience with me and help me with this problem.
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
|||How would I go about doing that .. I have tried to do the ODBC on my computer
setting up a SWL access to the computer and I still can't hit it..
"SKG" wrote:

> Can u connect using query analyser.?
> "SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
> news:%23w2amiThEHA.1156@.TK2MSFTNGP10.phx.gbl...
> installed
> ftp
> hook
> supports Post Alerts, Ratings, and Searching.
>
>
|||Okay when I ran the ODBC on the local server I found no problems
"Peter" wrote:
[vbcol=seagreen]
> How would I go about doing that .. I have tried to do the ODBC on my computer
> setting up a SWL access to the computer and I still can't hit it..
> "SKG" wrote:

Data Connection problems - Database not found

I resently purchased a Virtual Windows 2003 Standard Server and I installed
SQL 2000 with Service Pack 3 on it to make sure it was up to date. I can ft
p
on this server and everthing but when it comes to making a Microsoft ODBC
connection from my local computer to the virtual server I am not able to hoo
k
up with it I recive a server time out is there something someone can be
patience with me and help me with this problem.
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine sup
ports Post Alerts, Ratings, and Searching.Can u connect using query analyser.?
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:%23w2amiThEHA.1156@.TK2MSFTNGP10.phx.gbl...
> I resently purchased a Virtual Windows 2003 Standard Server and I
installed
> SQL 2000 with Service Pack 3 on it to make sure it was up to date. I can
ftp
> on this server and everthing but when it comes to making a Microsoft ODBC
> connection from my local computer to the virtual server I am not able to
hook
> up with it I recive a server time out is there something someone can be
> patience with me and help me with this problem.
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.|||How would I go about doing that .. I have tried to do the ODBC on my compute
r
setting up a SWL access to the computer and I still can't hit it..
"SKG" wrote:

> Can u connect using query analyser.?
> "SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
> news:%23w2amiThEHA.1156@.TK2MSFTNGP10.phx.gbl...
> installed
> ftp
> hook
> supports Post Alerts, Ratings, and Searching.
>
>|||Okay when I ran the ODBC on the local server I found no problems
"Peter" wrote:
[vbcol=seagreen]
> How would I go about doing that .. I have tried to do the ODBC on my compu
ter
> setting up a SWL access to the computer and I still can't hit it..
> "SKG" wrote:
>

Data connection problem between Assess front end and SQL server behind firewall

I have an Access 2000 front end (on win 98) for a SQL 2000 database (on win 2000 server) behind a firewall. A port (1433) was opened for connecting the Access front end to the SQL database. The odbc system DSN connection showed data source "TESTS COMPLETED SUCCESSFULLY!". However, the Access front end still does not work. The same Access program works well within the firewall. Could anyone tell me what could possible be wrong?What error does Access return?

Data connection error - Please help

Thanks in advance to anyone that can help me with this.

We have software in a production environment that uses a DSN-Less connection to access an Access Database. The software was written in VB6 and uses MDAC 2.8

99% of customers have no issues with the software connecting the the database however once in while we encounter a customer that get's the following error:

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Except for the DB path the rest of the connection string is hardcoded in the app so there is no difference in the name of the driver used on 99% of the working installations and the 1% that fail. The debug log returned by the customer shows that the following connection string is being used:

Driver={Microsoft Access Driver (*.mdb)};Uid=xxxx;Pwd=xxx;Dbq=C:\Windows\SomeSubDir\ourAccessDB;

We have verfied the following:

1. Our Access DB must be placed under a subdirectory of the main Windows directory. There is special reason for this but it would take too long to explain. However, I have confirmed that the database can be accessed and the user has full permissions on these folders. The can create new files in the same directory, etc.

2. Customer is running Windows XP SP2. Has MDAC 2.8 installed as well as the MS Jet SP8

3. Customer confirms that the entry "Microsoft Access Drive (*.mdb)" shows up in the driver tab of the ODBC panel.

4. I have discovered that I can only reproduce that error on our development systems if I change the connection string to use a driver that doesn't exist (e.g. Driver={Mosoft Access Driver (*.mdb)}

5. Latest users states that this is a "clean" system that is fairly new.

Any ideas would be greatly appreciated.

Take a look at this support article

http://support.microsoft.com/default.aspx/kb/271908

Hope this helps

data connection behind firewall

Hello,

I am trying to connect a web app to a SQL 2005 that is behind a firewall.

The challenge is this, the SQL is behind a firewall and the webserver is at a different location. From my desktop development environment, I connect through a VPN first and then can point to the internal IP of the DB server. This works fine as long as the VPN is connected.

But how do I do this from a hosted web application that is not on my local machine or using my VPN?

Is there some sort of tunneling Connection that I can use within code?

thanks

As you are going to deploy the web site to a remote location, to have SQL Connection via Tabular Data Stream would require opening up extra ports (1433 and 1434) - since the days of the Slammer worm, I doubt if any person in charge of a company network would allow these ports to be opended up to the outside world.

Can you deploy a copy of the database to the remote site? You could use SQL Express provided the database size was within 2Gb. Alternatively you write a web service, which only require Port 80 to be open through the firewall from your external host into your DMZ.

|||

Thanks for the reply. The challenge is that there is a database collecting live survey data...and that DB is in a different physical location behind a firewall, etc.

The application I am writting is on a different server/ different building, etc. The DB server has VPN access to it but I don't know how to include that in my code so that my app can talk to it and pull the live data.

(and you are correct, just opening those ports would be dangerous.)

|||

In which case you need to have the database both on the remote server on within your LAN. As it is a survey database, would i be correct to asume that data is only every inserted (unlil a survey is deleted en-mass)?

In which case include a web service on your remote server, set only to respond to the IP address of your LAN. Depending on the senitivity of your data you may elect to run HTTPS for the web service.

The key point is identifying batches of records to copy. Without knowing your database, I cannot comment of the best means of setting up the database to do this. If only inserting as I have suggested that you need a method that will return a manageable block of records. This method will be called by a Windows Service on a machine within your LAN which will then call a "make it so" stored procedure on your local database.

The required ports will be already open from your LAN out and into your remote IIS server.

Data Connection

So after a few hours of banging my head against my computer, here I am. :)

Backstory: A few weeks ago I installed web matrix and MSDE Rel A so I could create some .NET pages from my local machine, connect to a remote SQL Server 2000 database, and then post the .NET pages on the web server. All went well, I could connect to the datasource it brought up the table column names, everything was perfectly working (should've been my first hint to leave well enough alone). Well today, I think, "hey you know I want to give this new Visual Studio 2005 Express Edition a try". So I install it. I thought that if web matrix was that simple to connect, create and post "surely" VSE would be too, but with more features. I also read how I should go ahead and install SQL Server express and SQL Server Managment Studio Express, so I did.

So I go to create a datasource in VSE, but VSE had other plans. An error message popped up. Something to the effect, "An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be cuased by the fact that under the default settings SQL Server does not allow remote connections..." I noticed that it said something about SQL Server 2005 so I figured I'd need to change that so I used the Microsoft SQL Server (OLE DB). It returned the error "[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied". I flipped back over to web matrix and now it doesn't work either. I have tried referencing the server by servername\db_name and ip address as well. All result in the same.

Any thoughts on how to get me going?

Try .\SQLEXPRESS

Data access from multiple datasources

Hi,
How to data access from multiple datasources in a crystal report designer?
For one datasource : we can go for connection and connect to our system DSN via ODBC or Native driver connection.Hi,

You can use subreports to access different datasources, if you want to link data from seperate data sources in one query you can obviously not use this approach. Instead I would use a database link from one database to the other data sources.

- Jukka

DAC not supported.

SQL2K5
SP1
Howdy all. I'm trying to open up Dedicated Admins Connection in Management
Studio and getting "DAC's are not supported. (Object Explorer)"
Any idea's?
TIA, ChrisRYou may need to enable the sp_configure option 'remote admin connections'.
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:E3F6FEC3-CFEC-4494-9742-B6AC1BA02242@.microsoft.com...
> SQL2K5
> SP1
> Howdy all. I'm trying to open up Dedicated Admins Connection in Management
> Studio and getting "DAC's are not supported. (Object Explorer)"
> Any idea's?
> TIA, ChrisR|||DAC is not supported for the object explorer, only for the query window.
--
HTH
Kalen Delaney, SQL Server MVP
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:E3F6FEC3-CFEC-4494-9742-B6AC1BA02242@.microsoft.com...
> SQL2K5
> SP1
> Howdy all. I'm trying to open up Dedicated Admins Connection in Management
> Studio and getting "DAC's are not supported. (Object Explorer)"
> Any idea's?
> TIA, ChrisR|||Hi,
you may check my screencasts on my site, one topic is about enabling
DAC.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||Thanks Kalen, that was it.
"Kalen Delaney" wrote:
> DAC is not supported for the object explorer, only for the query window.
> --
> HTH
> Kalen Delaney, SQL Server MVP
>
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:E3F6FEC3-CFEC-4494-9742-B6AC1BA02242@.microsoft.com...
> > SQL2K5
> > SP1
> >
> > Howdy all. I'm trying to open up Dedicated Admins Connection in Management
> > Studio and getting "DAC's are not supported. (Object Explorer)"
> >
> > Any idea's?
> >
> > TIA, ChrisR
>
>

DAC not supported.

SQL2K5
SP1
Howdy all. I'm trying to open up Dedicated Admins Connection in Management Studio and getting "DAC's are not supported. (Object Explorer)"
Any idea's?
TIA, cfrBy default, the DAC is only available via the SQLCMD command line utility. I think it can be opened up to other things, but MS figured that ocule be a security risk.|||Got it. It cant be used through MGMT Studio, only a query window.

Thanks.

DAC not supported.

SQL2K5
SP1
Howdy all. I'm trying to open up Dedicated Admins Connection in Management
Studio and getting "DAC's are not supported. (Object Explorer)"
Any idea's?
TIA, ChrisRYou may need to enable the sp_configure option 'remote admin connections'.
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:E3F6FEC3-CFEC-4494-9742-B6AC1BA02242@.microsoft.com...
> SQL2K5
> SP1
> Howdy all. I'm trying to open up Dedicated Admins Connection in Management
> Studio and getting "DAC's are not supported. (Object Explorer)"
> Any idea's?
> TIA, ChrisR|||DAC is not supported for the object explorer, only for the query window.
HTH
Kalen Delaney, SQL Server MVP
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:E3F6FEC3-CFEC-4494-9742-B6AC1BA02242@.microsoft.com...
> SQL2K5
> SP1
> Howdy all. I'm trying to open up Dedicated Admins Connection in Management
> Studio and getting "DAC's are not supported. (Object Explorer)"
> Any idea's?
> TIA, ChrisR|||Hi,
you may check my screencasts on my site, one topic is about enabling
DAC.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--|||Thanks Kalen, that was it.
"Kalen Delaney" wrote:

> DAC is not supported for the object explorer, only for the query window.
> --
> HTH
> Kalen Delaney, SQL Server MVP
>
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:E3F6FEC3-CFEC-4494-9742-B6AC1BA02242@.microsoft.com...
>
>

DAC doen't work with explicit port number

Hello everybody,

After install SQL 2005 I noticed than DAC (Dedicated Admin Connection) is started with dynamic port.

2006-08-08 12:19:47.870 Server Server is listening on [ 'any' <ipv4> 14330].
2006-08-08 12:19:47.880 Server Server is listening on [ 'any' <ipv4> 1433].
2006-08-08 12:19:47.880 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\A ].
2006-08-08 12:19:47.880 Server Server local connection provider is ready to accept connection on [ \\.\pipe\MSSQL$A\sql\query ].
2006-08-08 12:19:47.900 Server Server is listening on [ 'any' <ipv4> 1212].
2006-08-08 12:19:47.900 Server Dedicated admin connection support was established for listening remotely on port 1212.

My question:
Is possible fix port for DAC?
How can I use DAC behind a firewall if I don't know witch port it will use?

Ok, the BOL say: If SQL Server is configured to accept remote administration connections, the DAC must be initiated with an explicit port number:
sqlcmd –Stcp:<server>,<port> (By the way, not is need -A parameter ?)

but it doen't work for me!

Por default connection I have:
C:\sqlcmd -A -SSERVER01\A -Usa -P123456 -dmaster

sys.dm_exec_connections say:
connect_time net_transport client_tcp_port local_tcp_port
-- - --
2006-08-08 12:24:05.750 TCP 3143 1433
2006-08-08 12:49:56.513 TCP 3273 1212

Specifying port I have:
C:\sqlcmd -A -Stcp:SERVER01,1434 -Usa -P123456 -dmaster

but I get "Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired."

PS: I try with any port but always receive timeout !!!

May someone help please..

Thx
Nilton Pinheiro

Hello peoples,

Please....

Is possible fix port for DAC?
How can I use DAC behind a firewall if I don't know witch port it will use?

thx.
Nilton Pinheiro

Customizing the connection string to the server where sp will be created?

When you create a SQL server project, it asks you for the connection string to the database. Can I change this connection string at run time?. By the way it is included in the project properties at desing time.I don't really understand the question - the connection string you mention is the string which tells VS where the assembly and procs etc will be deployed, when you do Deployment - at wich stage would you like to change the string? When your code is invoked eventually, the connection string is not used.

Niels