Relationships in Management Studio Express connected to SQL Server Compact Edition

Hello ,
Is possible to specify reationships between tables on SQL Server Compact Edition database in Management Studio Express ?

I can connect to database file , add tables, add data , but I dont't found the right methot to specify reationships as with SQL Server Express.

Any ideas?

Have you found an answer?

Gus

|||

You have to specify the relationships in the query analyzer, like this:

ALTER TABLE MyOrders ADD FK_CustOrder FOREIGN KEY (CustID) REFERENCES MyCustomers(CustID)|||Thanks Erik for the information. I know it can be done in code, I was hoping to find the complete table designer in the ce edition. I understand that it's not there. Apparently 'lightweight' refers not just to the product's functional capabilities, but also its development tools.|||Designing relationships visually will be available in the next version of SQL CE, version 3.5, included in Visual Studio "Orcas".sql

Relationships in Management Studio Express connected to SQL Server Compact Edition

Hello ,
Is possible to specify reationships between tables on SQL Server Compact Edition database in Management Studio Express ?

I can connect to database file , add tables, add data , but I dont't found the right methot to specify reationships as with SQL Server Express.

Any ideas?

Have you found an answer?

Gus

|||

You have to specify the relationships in the query analyzer, like this:

ALTER TABLE MyOrders ADD FK_CustOrder FOREIGN KEY (CustID) REFERENCES MyCustomers(CustID)|||Thanks Erik for the information. I know it can be done in code, I was hoping to find the complete table designer in the ce edition. I understand that it's not there. Apparently 'lightweight' refers not just to the product's functional capabilities, but also its development tools.|||Designing relationships visually will be available in the next version of SQL CE, version 3.5, included in Visual Studio "Orcas".

Relationship diagram

Hi there,

I just set up my AppData and i'm trying to connect the Membership to a tbl_Profile that i created.
I notice there's an application_id and a user_id which are uniqueidentifiers. I've been trying create a relationship to tbl_Profile's user_id column but it won't let me saying it's not compatible. Am i suppose to set tbl_Profile's user_id column to int or uniqueidentifier? I've tried both and it won't let me...

THanks!

Hello lilboi,

Are there records in the table of which you try to change the column to int or uniqueidentifier?

When the original column type is char(n)/string, you can't change it to int or uniqueidentifier, because the conversion fails.

What relationship are you trying to create? Between what tables and what fields?

Jeroen Molenaar.

|||

hi jeroenm!

There are no records yet. So I was able to have it as int, but it wouldn't connect. THen i changed it to uniqueidentifier but it still wouldn't connect.

WHen i mean by connecting, i meant, when i try to draw a relationship between the column user_id for both the tables.

Thanks!

|||

Let me try to explain:

aspnet_Membership tbl_Profile
---------- -----
user_id 1----to----1 user_id

I try to draw a 1 to 1 relationship by going through Relationship Diagram and then dragging user_id(Profile) to user_id(Membership)

ReInstalling Katmai.

I cannot reinstall Katmai.
Somehow, I created a situation where Management Studio could not connect to reporting services. Being unable to diagnose why, I decided to uninstall and reinstall. I had installed everything. After running about 10 uninstalls, I went to C:/Program Files/ and blasted the whole Microsoft SQL Server tree. I went to the registry and did the same thing in HKLM/Software/Microsoft/Microsoft SQL Server.
I rebooted. The error message: An instance with the same name is already installed on this computer. I'm guessing the setup program detected MSSQLSERVER in some registry key, and not another instance, but if I knew which one, I wouldn't be posting to this forum.

It may be that Control Panel|Administrative Tools|Services has an SQL Server(InstanceName) entry.
sql

Reinstall SQL Server 2005 Problem (cannot connect to <server>)

I had installed SQL Server 2005 for the first time in order to study for the SQL SERVER 2005 Implementation and Maintenance exam. Everything was going ok until I got to the section on Partitions. When I attempted to follow the lessons on partitions, I received an error indicating that the Enterprise Edition was needed for Partitions.

I uninstalled SQL Server and re-installed the Enterprise Edition (MSDN disk). When I re-installed, I was not promopted for a new/default instance name). The old instance that had used for the original installation is presented when I attempt to "Connect to Server." When I select that instance and click Connect, I receive the "Cannot connect to <server name>" error message.

How do I re-establish that instance name or create another default instance?

Regards - Tony

Would you check Control Panel -> Add/Remove Programs? If there is still SQL Server 2005 entry, please choose it and click change, then click Report button to get all information about SQL Server 2005. The report will tell you which components of SQL Server 2005 are still existing on your machine.

Based on your description, maybe the previous SQL Server 2005 has not been uninstalled successfully.

If you do not mind, you can type in a new instance name to install another instance as multiple instacnes are supported provided that you have enough resourses such as free disk space.

Registry entries for application to connect to remote SQL Server DB

I am trying to switch a PowerBuilder application from using a local database (SQL Anywhere) to a remote SQL Server database. I am getting IM002 after defining the data source and pointing the application to the datasource.
Can someone please send me some examples of Registry entries where an application is pointed to a remote SQL Server database?
IM002 is not a SQL Server error message. This seems to be a power builder issue, and I think you have a batter
chance to get good advice in a PowerBuilder newsgroup...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rajeev" <rlpd@.hotmail.com> wrote in message news:72091455-61D9-475E-B9AB-5DAF5A1DE604@.microsoft.com...
> I am trying to switch a PowerBuilder application from using a local database (SQL Anywhere) to a remote SQL
Server database. I am getting IM002 after defining the data source and pointing the application to the
datasource.
> Can someone please send me some examples of Registry entries where an application is pointed to a remote SQL
Server database?

Registry entries for application to connect to remote SQL Server DB

I am trying to switch a PowerBuilder application from using a local database
(SQL Anywhere) to a remote SQL Server database. I am getting IM002 after d
efining the data source and pointing the application to the datasource.
Can someone please send me some examples of Registry entries where an applic
ation is pointed to a remote SQL Server database?IM002 is not a SQL Server error message. This seems to be a power builder is
sue, and I think you have a batter
chance to get good advice in a PowerBuilder newsgroup...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rajeev" <rlpd@.hotmail.com> wrote in message news:72091455-61D9-475E-B9AB-5DAF5A1DE604@.micro
soft.com...
> I am trying to switch a PowerBuilder application from using a local database (SQL
Anywhere) to a remote SQL
Server database. I am getting IM002 after defining the data source and poin
ting the application to the
datasource.
> Can someone please send me some examples of Registry entries where an application
is pointed to a remote SQL
Server database?

Registry entries for application to connect to remote SQL Server DB

I am trying to switch a PowerBuilder application from using a local database (SQL Anywhere) to a remote SQL Server database. I am getting IM002 after defining the data source and pointing the application to the datasource
Can someone please send me some examples of Registry entries where an application is pointed to a remote SQL Server database?IM002 is not a SQL Server error message. This seems to be a power builder issue, and I think you have a batter
chance to get good advice in a PowerBuilder newsgroup...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rajeev" <rlpd@.hotmail.com> wrote in message news:72091455-61D9-475E-B9AB-5DAF5A1DE604@.microsoft.com...
> I am trying to switch a PowerBuilder application from using a local database (SQL Anywhere) to a remote SQL
Server database. I am getting IM002 after defining the data source and pointing the application to the
datasource.
> Can someone please send me some examples of Registry entries where an application is pointed to a remote SQL
Server database?

Registering SQL Server...

Hi,
I am trying to connect remotely to a client's MSDE database with my SQL
Enterprise Manager so I can administer the database. I have established a
VPN to the client which I can ping and terminal serve into the server but I
cannot register the server with the SQL Enterprise Manager. I have even
tried turning off my Windows Firewall.
What connection property am I missing at either the client site or at my
office that is preventing me from connecting?
Thanks,
Chris
hi Chris,
Chris Marsh wrote:
> Hi,
> I am trying to connect remotely to a client's MSDE database with my
> SQL Enterprise Manager so I can administer the database. I have
> established a VPN to the client which I can ping and terminal serve
> into the server but I cannot register the server with the SQL
> Enterprise Manager. I have even tried turning off my Windows
> Firewall.
> What connection property am I missing at either the client site or at
> my office that is preventing me from connecting?
what kind of exception are you prompted with, at connection try?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I enter the IP into the Server line (leave Windows Auth or switch to SQL
Auth) and then I get the messagebox:
SQL Server registraion failed bause of hte connection falure displayed
below....
SQL Server does not exist or access denied.
ConnectionOpen (Connect())
Yes | No
Thanks!
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3cq5dpF6qk3gpU1@.individual.net...
> hi Chris,
> Chris Marsh wrote:
> what kind of exception are you prompted with, at connection try?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Did you make a portscan to see wheter the SQLServer is reachable and
listening on that adress ?
Perhaps the ports are blocked by the VPN Gateway, ping could be reachable
beacuse ICMP is treated in antoher way than ports. Its a own protocol:
http://www.iana.org/assignments/icmp-parameters
Try to use a portscanner.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Chris Marsh" <cmarsh@.synergy-intl.com> schrieb im Newsbeitrag
news:Or8DSspRFHA.3704@.TK2MSFTNGP12.phx.gbl...
>I enter the IP into the Server line (leave Windows Auth or switch to SQL
>Auth) and then I get the messagebox:
> SQL Server registraion failed bause of hte connection falure displayed
> below....
> SQL Server does not exist or access denied.
> ConnectionOpen (Connect())
> Yes | No
> Thanks!
>
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
> news:3cq5dpF6qk3gpU1@.individual.net...
>
|||Chris Marsh wrote:
> I enter the IP into the Server line (leave Windows Auth or switch to
> SQL Auth) and then I get the messagebox:
> SQL Server registraion failed bause of hte connection falure displayed
> below....
> SQL Server does not exist or access denied.
> ConnectionOpen (Connect())
which is a general error reported by the MDAC stack..
please have a look at
http://support.microsoft.com/default...06&Product=sql
for a list of the more common causes of this kind of exception
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Chris, see an earlier post 'Getting to the bottom of ..." in the
subject. (just a few days ago).
If it's running on XP it's an XP login problem which can be cured on
the XP/Msde machine. There's a long explanation of how to cure this
(without re-installing).
It's not an MDAC problem. Come on MVP's you should know this stuff!
-Nick
On Thu, 21 Apr 2005 12:35:05 -0400, "Chris Marsh"
<cmarsh@.synergy-intl.com> wrote:

>Hi,
>I am trying to connect remotely to a client's MSDE database with my SQL
>Enterprise Manager so I can administer the database. I have established a
>VPN to the client which I can ping and terminal serve into the server but I
>cannot register the server with the SQL Enterprise Manager. I have even
>tried turning off my Windows Firewall.
>What connection property am I missing at either the client site or at my
>office that is preventing me from connecting?
>Thanks,
>Chris
>

Registering Servers

In Enterprise Manager 2000 I was able to register multiple servers and next
time I opened it those servers would automatically connect. With SQL Server
Management Studio 2005 I can register multiple servers, but next time I open
it only the last one I had connected shows. Is there a way to maintain
multiple connections?
Hi Gary
I believe the object browser will show the server that you have logged into,
you will need to log into the other servers to get them in object explorer.
You want to raise this as an request at
http://lab.msdn.microsoft.com/produc...k/default.aspx
John
"Gary L" wrote:

> In Enterprise Manager 2000 I was able to register multiple servers and next
> time I opened it those servers would automatically connect. With SQL Server
> Management Studio 2005 I can register multiple servers, but next time I open
> it only the last one I had connected shows. Is there a way to maintain
> multiple connections?

Registering Servers

In Enterprise Manager 2000 I was able to register multiple servers and next
time I opened it those servers would automatically connect. With SQL Server
Management Studio 2005 I can register multiple servers, but next time I open
it only the last one I had connected shows. Is there a way to maintain
multiple connections?Hi Gary
I believe the object browser will show the server that you have logged into,
you will need to log into the other servers to get them in object explorer.
You want to raise this as an request at
http://lab.msdn.microsoft.com/produ...ck/default.aspx
John
"Gary L" wrote:

> In Enterprise Manager 2000 I was able to register multiple servers and nex
t
> time I opened it those servers would automatically connect. With SQL Serv
er
> Management Studio 2005 I can register multiple servers, but next time I op
en
> it only the last one I had connected shows. Is there a way to maintain
> multiple connections?

Registering Servers

In Enterprise Manager 2000 I was able to register multiple servers and next
time I opened it those servers would automatically connect. With SQL Server
Management Studio 2005 I can register multiple servers, but next time I open
it only the last one I had connected shows. Is there a way to maintain
multiple connections?Hi Gary
I believe the object browser will show the server that you have logged into,
you will need to log into the other servers to get them in object explorer.
You want to raise this as an request at
http://lab.msdn.microsoft.com/productfeedback/default.aspx
John
"Gary L" wrote:
> In Enterprise Manager 2000 I was able to register multiple servers and next
> time I opened it those servers would automatically connect. With SQL Server
> Management Studio 2005 I can register multiple servers, but next time I open
> it only the last one I had connected shows. Is there a way to maintain
> multiple connections?

Registering Error

I am trying to register the SQL server 6.5 in SQL server 2000 I am getting
error
"SLQ Server does exist or access denied(ConnectionOpern(connect))
where is the problem its urgent can any body help me
Yousuf Khan
Programmer
I assume that you want to manage 6.5 from Enterprise Manager 2000? If so, can't be done. You need to
use EM 6.5 to manage 6.5.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Yousuf" <yousuf.yk@.gmail.com> wrote in message
news:82FCC446-36CC-423C-BF4F-EF60039BC984@.microsoft.com...
>I am trying to register the SQL server 6.5 in SQL server 2000 I am getting
> error
> "SLQ Server does exist or access denied(ConnectionOpern(connect))
> where is the problem its urgent can any body help me
> --
> Yousuf Khan
> Programmer
|||i wanted to import the databeses of 6.5 into 2000 thats y i wanted to
registers it first
Yousuf Khan
Programmer
"Tibor Karaszi" wrote:

> I assume that you want to manage 6.5 from Enterprise Manager 2000? If so, can't be done. You need to
> use EM 6.5 to manage 6.5.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Yousuf" <yousuf.yk@.gmail.com> wrote in message
> news:82FCC446-36CC-423C-BF4F-EF60039BC984@.microsoft.com...
>
>
|||Such an "import" is performed using the SQL Server 2000 Upgrade Wizard (found in the "Microsoft SQL
server - Switch" program group).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Yousuf" <yousuf.yk@.gmail.com> wrote in message
news:DE8EB7CB-A9A2-4D0F-8E07-CD9E93D554D4@.microsoft.com...[vbcol=seagreen]
>i wanted to import the databeses of 6.5 into 2000 thats y i wanted to
> registers it first
> --
> Yousuf Khan
> Programmer
>
> "Tibor Karaszi" wrote:

Registering Error

I am trying to register the SQL server 6.5 in SQL server 2000 I am getting
error
"SLQ Server does exist or access denied(ConnectionOpern(connect))
where is the problem its urgent can any body help me
Yousuf Khan
ProgrammerI assume that you want to manage 6.5 from Enterprise Manager 2000? If so, ca
n't be done. You need to
use EM 6.5 to manage 6.5.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Yousuf" <yousuf.yk@.gmail.com> wrote in message
news:82FCC446-36CC-423C-BF4F-EF60039BC984@.microsoft.com...
>I am trying to register the SQL server 6.5 in SQL server 2000 I am getting
> error
> "SLQ Server does exist or access denied(ConnectionOpern(connect))
> where is the problem its urgent can any body help me
> --
> Yousuf Khan
> Programmer|||i wanted to import the databeses of 6.5 into 2000 thats y i wanted to
registers it first
Yousuf Khan
Programmer
"Tibor Karaszi" wrote:

> I assume that you want to manage 6.5 from Enterprise Manager 2000? If so,
can't be done. You need to
> use EM 6.5 to manage 6.5.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Yousuf" <yousuf.yk@.gmail.com> wrote in message
> news:82FCC446-36CC-423C-BF4F-EF60039BC984@.microsoft.com...
>
>|||Such an "import" is performed using the SQL Server 2000 Upgrade Wizard (foun
d in the "Microsoft SQL
server - Switch" program group).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Yousuf" <yousuf.yk@.gmail.com> wrote in message
news:DE8EB7CB-A9A2-4D0F-8E07-CD9E93D554D4@.microsoft.com...[vbcol=seagreen]
>i wanted to import the databeses of 6.5 into 2000 thats y i wanted to
> registers it first
> --
> Yousuf Khan
> Programmer
>
> "Tibor Karaszi" wrote:
>

Registering Error

I am trying to register the SQL server 6.5 in SQL server 2000 I am getting
error
"SLQ Server does exist or access denied(ConnectionOpern(connect))
where is the problem its urgent can any body help me
--
Yousuf Khan
ProgrammerI assume that you want to manage 6.5 from Enterprise Manager 2000? If so, can't be done. You need to
use EM 6.5 to manage 6.5.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Yousuf" <yousuf.yk@.gmail.com> wrote in message
news:82FCC446-36CC-423C-BF4F-EF60039BC984@.microsoft.com...
>I am trying to register the SQL server 6.5 in SQL server 2000 I am getting
> error
> "SLQ Server does exist or access denied(ConnectionOpern(connect))
> where is the problem its urgent can any body help me
> --
> Yousuf Khan
> Programmer|||i wanted to import the databeses of 6.5 into 2000 thats y i wanted to
registers it first
--
Yousuf Khan
Programmer
"Tibor Karaszi" wrote:
> I assume that you want to manage 6.5 from Enterprise Manager 2000? If so, can't be done. You need to
> use EM 6.5 to manage 6.5.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Yousuf" <yousuf.yk@.gmail.com> wrote in message
> news:82FCC446-36CC-423C-BF4F-EF60039BC984@.microsoft.com...
> >I am trying to register the SQL server 6.5 in SQL server 2000 I am getting
> > error
> > "SLQ Server does exist or access denied(ConnectionOpern(connect))
> > where is the problem its urgent can any body help me
> >
> > --
> > Yousuf Khan
> > Programmer
>
>|||Such an "import" is performed using the SQL Server 2000 Upgrade Wizard (found in the "Microsoft SQL
server - Switch" program group).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Yousuf" <yousuf.yk@.gmail.com> wrote in message
news:DE8EB7CB-A9A2-4D0F-8E07-CD9E93D554D4@.microsoft.com...
>i wanted to import the databeses of 6.5 into 2000 thats y i wanted to
> registers it first
> --
> Yousuf Khan
> Programmer
>
> "Tibor Karaszi" wrote:
>> I assume that you want to manage 6.5 from Enterprise Manager 2000? If so, can't be done. You need
>> to
>> use EM 6.5 to manage 6.5.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Yousuf" <yousuf.yk@.gmail.com> wrote in message
>> news:82FCC446-36CC-423C-BF4F-EF60039BC984@.microsoft.com...
>> >I am trying to register the SQL server 6.5 in SQL server 2000 I am getting
>> > error
>> > "SLQ Server does exist or access denied(ConnectionOpern(connect))
>> > where is the problem its urgent can any body help me
>> >
>> > --
>> > Yousuf Khan
>> > Programmer
>>