Can start new database from Web Matrix

I am running Web Matrix version 0.5, .Net version 1.1 on a computer with XP Pro.

Web Matrix works fine and returns forms properly.

I installed MSDE from the website (SQL2KDeskSP3a.exe) Ibelieve that SQL Server IS running, because I see the tower icon with agreen arrow; when I double-click that I get a message that it isrunning SQL Server.

When I click the "data" tab in Web Matrix I get the blankworkspace. Then I click the New Connection icon at the top left,which opens up a dialog box. I change "Windows Authentication" to"SQL Authentication." That opens up the Username/Passwordprompt. I am entering "sa" for the username (I AM NOT SURE IFTHAT IS CORRECT) and "**secret**" for the password (that's what Ientered in the command prompt when I setup the MSDE). Then Iclick "Create a New Database." I am asked to enter a name.

After a pause, I get an error message: "Unable to connect tothe database server. SQL Server does not exist or access denied.Connection Open (Connect ( )). OK

Do you have any ideas?

I installed the newer (version 0.6) Matrix and now I can find the database.

Can SSIS package be run from WebService?

Dear,

Can SSIS package be run from WebService?

P.S. SSIS package and Webservice are located in the same computer.

Thanks much!

It is solved.

And 1 more quest. How can I check the saved SSIS package in Microsoft SQL Server Management Studio?

Thanks much!

|||

Yes. When you connect to a server from SQL Server Management studio - change the Server type from 'Database Engine' to 'Integration Services'

Hope that helps.

Thanks,
Loonysan

|||

Thanks for your reply.

Once I click the MSDB folder, the error message, Login timeout expired is shown.

Do you have any idea about it?

Thanks

|||

Hi Michael,

The follwoing URL - http://emea.windowsitpro.com/SQLServer/Article/ArticleID/46723/46723.html
(Look at Roles section) talks about the various security permissions required to access/execute SSIS packages.

If this doesn't help - Please post this question in a new thread.

Thanks,
Loonysan

|||

Sorry I don't find "Roles Section" mentioned in the URL u post to me.

Could u mind explanning to me or give me another URL for me to reference?

Thanks much!

|||

Search for "Roles" in that URL - the second found result is the start of Roles section.

Hope that helps.

Thanks,
Loonysan

|||

Sorry.. I just found 1 "Roles" in the URL, http://emea.windowsitpro.com/Articles/Index.cfm?ArticleID=46723&DisplayTab=Article u given.

The content is as the below

Security in SSIS

Like every other feature in SQL Server 2005 Integration Services (SSIS), the product's new security features are noticeably different from their DTS counterparts. SSIS still uses passwords and encrypts sensitive data, but the approach has changed substantially, simplifying automated package execution, protection, scheduling, and editing. SSIS security features fall into five functional categories: encryption, for securing packages or parts of packages; sensitive-data protection, for identifying and protecting passwords and other sensitive data; SQL Server roles, for controlling access to packages stored in SQL Server; digital code signing, for ensuring that a package hasn't changed; and integration of SQL Server Agent subsystems, for securely storing and executing packages. Let's take a closer look at these new security features and get some guidelines for how and when to use them. I'd like to extend special thanks to Sergei Ivanov, the Integration Services team developer who wrote these features, for answering all my questions and making sure I got the details right. . . .

Thanks for your help!

|||

Not sure why you aren;t able to see the following text in that URL

Roles

SSIS adds three new roles that affect the way you run packages in SQL Server Agent and access packages stored in SQL Server. The db_dtsoperator role is the most limited new role. Users in this role can only enumerate (i.e., determine which packages are available) and view existing packages; operators can't create or modify SSIS packages. The db_dtsltduser role lets users create and modify their own packages and enumerate existing packages. And the db_dtsadmin role lets users create, modify, enumerate, and view all packages. Systems administrators are automatically in the db_dtsadmin role.

You must be in one of these three roles to access SSIS packages. If you aren't, and you attempt to enumerate a package by opening the Packages node for the SSIS Server object explorer in SQL Server Management Studio, you'll get the error message that Figure 2 shows.

You can find the new SSIS roles in the Management Studio MSDB database node under the Security, Roles, Database roles node. These roles apply only to MSDB and control access to the sysdtspackages90 table through the stored procedures that Figure 3 shows. You can find sysdtspackages90 and the stored procedures for accessing it in MSDB.

If you look at the sysdtspackages90 table in MSDB, you'll see two columns of particular interest to this discussion. The readrole column specifies the logins or roles that have read access to the package. Readers can enumerate, execute, and export a package from SQL Server. The writerole column specifies the logins or roles that have write access to the package. Writers can delete, rename, edit, and save a package to SQL Server. By default, these two columns are null.

To open the Package Roles dialog box, right-click a package in the Packages node and select Package Roles, as Figure 4 shows. Figure 5 shows the Package Roles dialog box default settings. When the readrole column is null, all users in any SSIS package role can enumerate and read that package. When the writerole field is null, only users in the db_dtsadmin role and the package's creator can modify or delete the package. To prevent a role from viewing and executing a given package, you must remove the role from the Reader Role comma-separated list. You can also add other roles to the reader and writer role lists. For example, I can add the Agent User, Limited User, and Security Administrator roles to the package reader role by entering them in a comma-delimited list as SQLAgentUserRole, db_dtsltduser, and db_securityadmin. I can also assign users and roles to a package's writer role to let them perform write operations such as DELETE and MODIFY to that package only.

To better understand how these roles interact and see which role has what rights, take a look at Table 1, which shows the rights assigned to each role and the activities that a user in each role can do by default. The table shows that the db_dtsoperator role can't work with its own packages; this limitation exists because the db_dtsoperator role can create packages, so that role can't own any. The table also shows that the Writerole db_stsoperator can't import packages because you can't have a write role on a non-existent package. The Assigned User isn't really a role, but I included it because you can assign a SQL login or role to a package reader or writer role. For example, by default, the db_dtsoperator isn't assigned to the writer role and doesn't have write privileges for packages. However, operators you explicitly place in the writer role will have all write-oriented privileges for that package.

By now your head is probably swimming in roles, but you need to know about one more new role in SQL Server 2005: the SQLAgentUserRole. A user must be in this role to create SQL Server Agent jobs, and users in this role can manage only the jobs that they create. This role is important because it affects a common SSIS usage scenario. After they're built, tested, and deployed, many packages reside on a SQL Server box in a back room somewhere, and a SQL Server Agent job triggers them when they need to run. Because SQL Server Agent integration is important to the security of such packages, let's take a closer look at how it works.

|||

Thanks for ur help.

But I find that I don't have any db_dtsoperator role in the server roles in DB and I cannot select different authentication mode once I login into Integration Services.

Can you give me some ideas? Thanks much!

Can SQL Express 2005 & MSDE reside on the same box?

Is the installation of MSDE and SQL Express 2005 on the same computer a supported configuration?

Many thanks

Yes, you can run Express and MSDE/WMSDE in the same machine using different instance names.

Can SQL 2000 restore database and user login on another server?

Can SQL 2000 restore user login and database to another
domain and computer name? If it can't, how to export user
login to another computer?
You can migrate logins from one server to another server by generating a
script using a routine called sp_help_revlogin. Here is an article I wrote
about it:
http://databasejournal.com/features/...le.php/2228611
----
-
Need SQL Server Examples check out my website
http://www.geocities.com/sqlserverexamples
"Mesak" <anonymous@.discussions.microsoft.com> wrote in message
news:481301c49fe2$d7215e10$a401280a@.phx.gbl...
> Can SQL 2000 restore user login and database to another
> domain and computer name? If it can't, how to export user
> login to another computer?

Can SQL 2000 restore database and user login on another server?

Can SQL 2000 restore user login and database to another
domain and computer name? If it can't, how to export user
login to another computer?You can migrate logins from one server to another server by generating a
script using a routine called sp_help_revlogin. Here is an article I wrote
about it:
http://databasejournal.com/features/mssql/article.php/2228611
--
----
----
-
Need SQL Server Examples check out my website
http://www.geocities.com/sqlserverexamples
"Mesak" <anonymous@.discussions.microsoft.com> wrote in message
news:481301c49fe2$d7215e10$a401280a@.phx.gbl...
> Can SQL 2000 restore user login and database to another
> domain and computer name? If it can't, how to export user
> login to another computer?

Can performance improve using RAID 0 if have only one CPU?

Hi,
If I have only one CPU in my SQL Server computer, can the performance have
any improvement by using RAID0?
Thanks
FrankWhy would you want to do that ? You would get peformance , no doubt, but no
fault tolerance.. You could go with RAID 1 or 1+ 0 to get performance and
the fault tolerance ..
"Frank" <wangping@.lucent.com> wrote in message
news:%23TxSv8NDFHA.1932@.TK2MSFTNGP14.phx.gbl...
> Hi,
> If I have only one CPU in my SQL Server computer, can the performance have
> any improvement by using RAID0?
> Thanks
> Frank
>|||Thanks Hassan,
I just read about the RAID, so I am wondering about this.
I think the RAID 0 will strip the data for read and write, if have more than
one processor, then the read and write can be done by different processors
on different strips. If only one processor, then I suspect there will be any
performance improvement for the processor to go to different strips.
Apprecite your further information
Frank
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OdsweGODFHA.2620@.tk2msftngp13.phx.gbl...
> Why would you want to do that ? You would get peformance , no doubt, but
no
> fault tolerance.. You could go with RAID 1 or 1+ 0 to get performance and
> the fault tolerance ..
> "Frank" <wangping@.lucent.com> wrote in message
> news:%23TxSv8NDFHA.1932@.TK2MSFTNGP14.phx.gbl...
have[vbcol=seagreen]
>|||Well you definitely need to worry about Fault Tolerance as disks have a high
possibility of going bad. And with regards to performance, you will not see
a whole lot of difference with regards to CPUs and IO read/writes . Your
performance could be looked at right from the application level. Why not
consider RAID 1 or RAID 1+ 0
How many disks along with size do you have and how much space do you need ?
"Frank" <wangping@.lucent.com> wrote in message
news:ueQ2gKODFHA.2232@.TK2MSFTNGP14.phx.gbl...
> Thanks Hassan,
> I just read about the RAID, so I am wondering about this.
> I think the RAID 0 will strip the data for read and write, if have more
than
> one processor, then the read and write can be done by different processors
> on different strips. If only one processor, then I suspect there will be
any
> performance improvement for the processor to go to different strips.
> Apprecite your further information
> Frank
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:OdsweGODFHA.2620@.tk2msftngp13.phx.gbl...
> no
and[vbcol=seagreen]
> have
>|||Frank,
you would likely see improvement by striping even with a single processor...
One processor can handle many concurrent IOs... As the others have said,
raid 0 gives you no fault tolerance... If a single disk in the stripe set
goes bad, everything will go down... Whether or not that is a requirement of
your configuration is a business decision...
Another way to increase IO throughput is to create several files within the
filegroup... This will allow sql to do parallel IO for a single query..
hope this helps.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23hp8RRODFHA.960@.TK2MSFTNGP09.phx.gbl...
> Well you definitely need to worry about Fault Tolerance as disks have a
> high
> possibility of going bad. And with regards to performance, you will not
> see
> a whole lot of difference with regards to CPUs and IO read/writes . Your
> performance could be looked at right from the application level. Why not
> consider RAID 1 or RAID 1+ 0
> How many disks along with size do you have and how much space do you need
> ?
> "Frank" <wangping@.lucent.com> wrote in message
> news:ueQ2gKODFHA.2232@.TK2MSFTNGP14.phx.gbl...
> than
> any
> and
>

Can performance improve using RAID 0 if have only one CPU?

Hi,
If I have only one CPU in my SQL Server computer, can the performance have
any improvement by using RAID0?
Thanks
Frank
Why would you want to do that ? You would get peformance , no doubt, but no
fault tolerance.. You could go with RAID 1 or 1+ 0 to get performance and
the fault tolerance ..
"Frank" <wangping@.lucent.com> wrote in message
news:%23TxSv8NDFHA.1932@.TK2MSFTNGP14.phx.gbl...
> Hi,
> If I have only one CPU in my SQL Server computer, can the performance have
> any improvement by using RAID0?
> Thanks
> Frank
>
|||Thanks Hassan,
I just read about the RAID, so I am wondering about this.
I think the RAID 0 will strip the data for read and write, if have more than
one processor, then the read and write can be done by different processors
on different strips. If only one processor, then I suspect there will be any
performance improvement for the processor to go to different strips.
Apprecite your further information
Frank
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OdsweGODFHA.2620@.tk2msftngp13.phx.gbl...
> Why would you want to do that ? You would get peformance , no doubt, but
no[vbcol=seagreen]
> fault tolerance.. You could go with RAID 1 or 1+ 0 to get performance and
> the fault tolerance ..
> "Frank" <wangping@.lucent.com> wrote in message
> news:%23TxSv8NDFHA.1932@.TK2MSFTNGP14.phx.gbl...
have
>
|||Well you definitely need to worry about Fault Tolerance as disks have a high
possibility of going bad. And with regards to performance, you will not see
a whole lot of difference with regards to CPUs and IO read/writes . Your
performance could be looked at right from the application level. Why not
consider RAID 1 or RAID 1+ 0
How many disks along with size do you have and how much space do you need ?
"Frank" <wangping@.lucent.com> wrote in message
news:ueQ2gKODFHA.2232@.TK2MSFTNGP14.phx.gbl...
> Thanks Hassan,
> I just read about the RAID, so I am wondering about this.
> I think the RAID 0 will strip the data for read and write, if have more
than
> one processor, then the read and write can be done by different processors
> on different strips. If only one processor, then I suspect there will be
any[vbcol=seagreen]
> performance improvement for the processor to go to different strips.
> Apprecite your further information
> Frank
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:OdsweGODFHA.2620@.tk2msftngp13.phx.gbl...
> no
and
> have
>
|||Frank,
you would likely see improvement by striping even with a single processor...
One processor can handle many concurrent IOs... As the others have said,
raid 0 gives you no fault tolerance... If a single disk in the stripe set
goes bad, everything will go down... Whether or not that is a requirement of
your configuration is a business decision...
Another way to increase IO throughput is to create several files within the
filegroup... This will allow sql to do parallel IO for a single query..
hope this helps.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23hp8RRODFHA.960@.TK2MSFTNGP09.phx.gbl...
> Well you definitely need to worry about Fault Tolerance as disks have a
> high
> possibility of going bad. And with regards to performance, you will not
> see
> a whole lot of difference with regards to CPUs and IO read/writes . Your
> performance could be looked at right from the application level. Why not
> consider RAID 1 or RAID 1+ 0
> How many disks along with size do you have and how much space do you need
> ?
> "Frank" <wangping@.lucent.com> wrote in message
> news:ueQ2gKODFHA.2232@.TK2MSFTNGP14.phx.gbl...
> than
> any
> and
>

Can performance improve using RAID 0 if have only one CPU?

Hi,
If I have only one CPU in my SQL Server computer, can the performance have
any improvement by using RAID0?
Thanks
FrankWhy would you want to do that ? You would get peformance , no doubt, but no
fault tolerance.. You could go with RAID 1 or 1+ 0 to get performance and
the fault tolerance ..
"Frank" <wangping@.lucent.com> wrote in message
news:%23TxSv8NDFHA.1932@.TK2MSFTNGP14.phx.gbl...
> Hi,
> If I have only one CPU in my SQL Server computer, can the performance have
> any improvement by using RAID0?
> Thanks
> Frank
>|||Thanks Hassan,
I just read about the RAID, so I am wondering about this.
I think the RAID 0 will strip the data for read and write, if have more than
one processor, then the read and write can be done by different processors
on different strips. If only one processor, then I suspect there will be any
performance improvement for the processor to go to different strips.
Apprecite your further information
Frank
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OdsweGODFHA.2620@.tk2msftngp13.phx.gbl...
> Why would you want to do that ? You would get peformance , no doubt, but
no
> fault tolerance.. You could go with RAID 1 or 1+ 0 to get performance and
> the fault tolerance ..
> "Frank" <wangping@.lucent.com> wrote in message
> news:%23TxSv8NDFHA.1932@.TK2MSFTNGP14.phx.gbl...
> > Hi,
> >
> > If I have only one CPU in my SQL Server computer, can the performance
have
> > any improvement by using RAID0?
> >
> > Thanks
> > Frank
> >
> >
>|||Well you definitely need to worry about Fault Tolerance as disks have a high
possibility of going bad. And with regards to performance, you will not see
a whole lot of difference with regards to CPUs and IO read/writes . Your
performance could be looked at right from the application level. Why not
consider RAID 1 or RAID 1+ 0
How many disks along with size do you have and how much space do you need ?
"Frank" <wangping@.lucent.com> wrote in message
news:ueQ2gKODFHA.2232@.TK2MSFTNGP14.phx.gbl...
> Thanks Hassan,
> I just read about the RAID, so I am wondering about this.
> I think the RAID 0 will strip the data for read and write, if have more
than
> one processor, then the read and write can be done by different processors
> on different strips. If only one processor, then I suspect there will be
any
> performance improvement for the processor to go to different strips.
> Apprecite your further information
> Frank
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:OdsweGODFHA.2620@.tk2msftngp13.phx.gbl...
> > Why would you want to do that ? You would get peformance , no doubt, but
> no
> > fault tolerance.. You could go with RAID 1 or 1+ 0 to get performance
and
> > the fault tolerance ..
> >
> > "Frank" <wangping@.lucent.com> wrote in message
> > news:%23TxSv8NDFHA.1932@.TK2MSFTNGP14.phx.gbl...
> > > Hi,
> > >
> > > If I have only one CPU in my SQL Server computer, can the performance
> have
> > > any improvement by using RAID0?
> > >
> > > Thanks
> > > Frank
> > >
> > >
> >
> >
>|||Frank,
you would likely see improvement by striping even with a single processor...
One processor can handle many concurrent IOs... As the others have said,
raid 0 gives you no fault tolerance... If a single disk in the stripe set
goes bad, everything will go down... Whether or not that is a requirement of
your configuration is a business decision...
Another way to increase IO throughput is to create several files within the
filegroup... This will allow sql to do parallel IO for a single query..
hope this helps.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23hp8RRODFHA.960@.TK2MSFTNGP09.phx.gbl...
> Well you definitely need to worry about Fault Tolerance as disks have a
> high
> possibility of going bad. And with regards to performance, you will not
> see
> a whole lot of difference with regards to CPUs and IO read/writes . Your
> performance could be looked at right from the application level. Why not
> consider RAID 1 or RAID 1+ 0
> How many disks along with size do you have and how much space do you need
> ?
> "Frank" <wangping@.lucent.com> wrote in message
> news:ueQ2gKODFHA.2232@.TK2MSFTNGP14.phx.gbl...
>> Thanks Hassan,
>> I just read about the RAID, so I am wondering about this.
>> I think the RAID 0 will strip the data for read and write, if have more
> than
>> one processor, then the read and write can be done by different
>> processors
>> on different strips. If only one processor, then I suspect there will be
> any
>> performance improvement for the processor to go to different strips.
>> Apprecite your further information
>> Frank
>> "Hassan" <fatima_ja@.hotmail.com> wrote in message
>> news:OdsweGODFHA.2620@.tk2msftngp13.phx.gbl...
>> > Why would you want to do that ? You would get peformance , no doubt,
>> > but
>> no
>> > fault tolerance.. You could go with RAID 1 or 1+ 0 to get performance
> and
>> > the fault tolerance ..
>> >
>> > "Frank" <wangping@.lucent.com> wrote in message
>> > news:%23TxSv8NDFHA.1932@.TK2MSFTNGP14.phx.gbl...
>> > > Hi,
>> > >
>> > > If I have only one CPU in my SQL Server computer, can the performance
>> have
>> > > any improvement by using RAID0?
>> > >
>> > > Thanks
>> > > Frank
>> > >
>> > >
>> >
>> >
>>
>

Can not start MSDE Service on win98

Can anyone please help me out, i installed the lastest MSDE on a win98 OS-Ver: 4.10.2222A
the install goes well, but when i restart the computer the sqlService manager icon appears blank, or red,

When i double click on the icon the SQL Server service manager appears but it can not access any instance running on my computer(it doesn't even find anything) by default the server and services comboboxes are empty and when i open those comboboxes they stay empty :(

I also can not use OSQL to log into the server, all i get is the following error: [TCP/IP sockets] specified sql server not found OS Error 120 (null)

I tried to do the following net start mssql$matrix
but it would just tell me that it has not service by that name.. even though i know it was installed with that instance name,

Inside the mssql$[someInstance] folder in my progfiles\sql server directory i read the error log and it says: SQL Server is terminating due to stop request from service control manager

What am i supposed to do now? DId anyone get this sort of trouble on a windows 98 SE machine?

ThanksCan you right click on the icon, and then from there select Start?

MSDE does work on Win98 SE.|||yes, it does install MSDE
but when i open up the sql manager app and try to start it manually i get this sweet error:

50 - Network request is not supported occured while performing this service operation on the MSSQLServer service

The network request is not supported.

God i've been spending hours on this looking for answer on the internet and nothing so far.|||well i just got another test PC out and this time it installed alright on the same type of Win98 machine. Weird.

But I still have a small problem inside OSQL I try to run the attach db statement

And I get this error message:
Msg 5172
Level 16
State 15
Server pc
Line 1

Header file for (filename) is not a valid database file header. The pageAudit property is incorrect.

What am i doing wrong? the statement is right...

Can not remotely connect to instance of sql server 2000

I had a big problem on connecting sqlserver remotely from other machines on the network .....

From any computer in the network i wanna to register the instance of the sqlserver from the enterprise manager ..... the server instance doesn't appear within the available sqlserver list (the servername which equal to my machine is the only one that appear) ..... when i manualy write the servername\alias manually and i choose the connection type and then i write sqlserver username and password and then finish he give a message to me that access denied or sql server doesn't exist ... !!

by the way from the local machine i registered the local instance of sqlserver successfully and successfully i access the Databases .....

To be noted:

I previously uninstalled this alias and i then i reinstalled it again with the same name and i attached the previously exists Databes.

in the same time i installed on the same machine sqlserver 2005 connectivity clients not the server itself.

Why are you using aliases? Do select @.@.servername, and tell me if this is the exact name you're trying to connect to via enterprise manager.|||

thank you for trying to help me,

I am using an alias from a long time and it was working good until i uninstalled the server and installed it agian .......

when i make "select @.@.servername" it return back "magedsalah\maged" and as i told before it works well on the local machine where i can connect with the enterprise manager to magedsalah\maged without any problems ......

the problem when anybody wanna to register magedsalah\maged in the enterprise manager of another computer the magedsalah\maged doesn't appear in the servers list what appear is magedsalah and it can't be registered and sometimes and some there is nothing appear at all.....

for further details plz refer to original message in the thread.....

thanks

|||Did you ever figure out the solution to this, I'm having the exact same problem, it occured after I installed Sql 2005, and now i'm using named instances.|||

Hi,

After i trapped in solving this problem ..... i removed the existing sql server 2000 where i use the alias and then i installed it again without alias (the default case in setup) ..... then i reattached my databases ......... and it works fine now

|||

I ended up doing the same thing too, and mine works too now. There must be a trick to making it work with alias'/instance names too though, oh well.

Thanks

Can not remote login to MSDE

I installed MSDE at my server at home, and that works fine.
On the server I can access my MSDE perfectly.
But, from a remote computer it seems impossible to connect.

Some (maybe) important information:

To create a user at my msde I used:

sp_addlogin (@. the MASTER DB)
sp_adduser (@. My DB)
sp_addrolemember (@. My DB)

Then I runned SVRNETCN.exe and enabled TCP/IP.

btw: I don't have a firewall running and both computers are on the same local network.is it trying to use windows integrated auth to connect, or mixed mode?|||It's configured for Mixed Mode...
I want to use sql-authentication and not windows authentication.
(it works localy, but not from an other computer)|||if it's running on a remote computer and U R using a firewall (XP...)
then try to open some port (1433) for the SQL Server DTS with the IP of the server...|||Nope, I don't have a firewall running...
I tried to telnet to 1433 to the MSDE, but even on the computer where my MSDE is running on, I can't get a telnet connection to 1433.
SQLServer uses tcp/ip, doesn't it?
I can't connect with VS.NET, Query Analyser, ... to my MSDE from an computer diferent than the computer that is running MSDE.|||I found out than my MSDE isn't 'registered' in my 'Data Sources (ODBC)'.
I registered it but...
It still doesn't work, but I think I am on the right spot :-)|||Ok, totaly wrong...
It has nothing to do with 'Data Sources (ODBC)'.
I tried everything!
It seems like MSDE isn't capable of listening at tcp/ip 1433.
Is this disabled in MSDE?|||try to check this:
on SQL Server configuration properties -> Connections
make sure the number is 0 (unlimited) or set it to 10 (for the test)
+
I did not hear U say U don't have a firewall on the server...|||I found it!!
I guess it's a bug in the install.
There is a key in the registry that contains no value:
..\MSSQLServer\SuperSocketNetLib\Tcp\tcpPort
The value has to be: 1433

But what if you have more than one instance?
You can't bind them all to the same port...
..\MSSQLServer\SuperSocketNetLib\Tcp\TcpDynamicPorts
It also doesn't contain a value...