Power Builder 6.5 Software

I need to know if the 6.5 version of Powerbuilder is
compatible with Windows XP.
If not please indicate the particular version and/or
alternative that is compatible with Windows XP.This is more of a Power Builder issue, you'll probably get a better response
in a Power Builder newsgroup!
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"bjbudgett@.kcc.usda.gov" <anonymous@.discussions.microsoft.com> wrote in
message news:104401c3b43c$0304f5c0$a501280a@.phx.gbl...
I need to know if the 6.5 version of Powerbuilder is
compatible with Windows XP.
If not please indicate the particular version and/or
alternative that is compatible with Windows XP.

Potential Problems

Does anyone know of any problems when running SQL Server
7.0 on a Windows 2000 Server? Just want to make sure I
don't put my self in a jam in the future.
ThanksHi,
I worked with W2k Advanced Server and sql server Standard ed 7.0 I never had problems
Regards
Carlos Augusto
Bogot=E1 Colombia
>--Original Message--
>Does anyone know of any problems when running SQL Server >7.0 on a Windows 2000 Server? Just want to make sure I >don't put my self in a jam in the future.
>Thanks
>.
>

Posting XMLA to AS from java without msmdpump.dll

I'm simply trying to invoke an Analysis Server CLR assembly procedure using MDX from a non windows machine in a a java environment. I also wish to require as little configuration on the SQL Server machine as possible.

Posting the request via HttpURLConnection as below works.

url = new URL("http://localhost//olap//msmdpump.dll ");
HttpURLConnection con = (HttpURLConnection) url.openConnection();

The question is I'd prefer not to have to require IIS plus the pump to be running on the AS server(msmdpump.dll). We know MS code is sending XMLA to the AS Database.

Why can we not use the same channel? It may not be http but I do not care. I'd rather have minimum stuff to do on the server.

Thanks in advance

Zub

I'd say in this stiuation you are probably better off using HTTP. On windows machine you can use naitive AS client : ADOMD.NET or AS OLEDB, and establish connection using TCP/IP , but coming from outside you will face quite a few problems. Configuring virtual direcory compared to ... for instance trying to figure out how to authenticate your non-windows user if by far easier task.

Hope that helps.

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

Post method in ASP stops working

I am having an issue on a windows 2003 box where I run a report to a new
window, and I do a request.form to get all my parameters. The first time I
run a report to a new window I am prompted for the windows user name and
password. Once I enter in the login info my report runs fine. Then when I try
to run another report to a new window the request.form doesn't work to pull
things in from my form. Everything is blank, so I get error messages. Another
report will not run until I shutdown IE restart IE log back into my website
and run the report.
My redirect string is
http://Session('sServer')/ReportServer?/Session("sProjectCode")/sReport &
"&rs:Command=render&rs:Format=HTML4.0&rc:Paramaters=False"
Can anyone tell me why the post method or Request.form will only work once
and then I have to restart IE. Again I am opening the report in a new window.
--
Thanks,
CraigI fixed this by going into IIS and going into the properties on the Reports
and ReportServer Virtual directories and under Directory security enabling
anonymous access.
"Craig" wrote:
> I am having an issue on a windows 2003 box where I run a report to a new
> window, and I do a request.form to get all my parameters. The first time I
> run a report to a new window I am prompted for the windows user name and
> password. Once I enter in the login info my report runs fine. Then when I try
> to run another report to a new window the request.form doesn't work to pull
> things in from my form. Everything is blank, so I get error messages. Another
> report will not run until I shutdown IE restart IE log back into my website
> and run the report.
> My redirect string is
> http://Session('sServer')/ReportServer?/Session("sProjectCode")/sReport &
> "&rs:Command=render&rs:Format=HTML4.0&rc:Paramaters=False"
> Can anyone tell me why the post method or Request.form will only work once
> and then I have to restart IE. Again I am opening the report in a new window.
> --
> Thanks,
> Craig

Possible to Use Windows Authentication on Peer to Peer Network?

Is there a way to use Windows Authentication to log on to an SQL server
instance accross a peer to peer network without a Domain?-- Right. Normally in a domain environment you're authenticated on the
domain and then use those credentials to authenticate to SQL.
If you're not in a domain, then you're in a workgroup.
Workgroup security. To connect to SQL using Windows Authetication, the
NT
username & passwords must match on both computers.
Yes (possible) and no (not recommandable).
-Yes: You can do this by choosing the same username and password on
both computers, the calling computer and the server. If you think now
"Well thats a bit weird...", I can acknowldge. The other possible
solution would be, if you use some programming language wich is able to
handle a security context, like C# with the appropiate classes, you
could impersonate the thread using the remote security context for
connecting.
-No: in common you cannot use integrated authentication across the
computers because the SQL Server can=B4t trust these unknown and
unreliable machines. Therefore a domain should be in place which can
guarantee with the user token for the real permissions of the user.
HTH, jens Suessmeyer.

Possible to Use Windows Authentication on Peer to Peer Network?

Is there a way to use Windows Authentication to log on to an SQL server
instance accross a peer to peer network without a Domain?
-- Right. Normally in a domain environment you're authenticated on the
domain and then use those credentials to authenticate to SQL.
If you're not in a domain, then you're in a workgroup.
Workgroup security. To connect to SQL using Windows Authetication, the
NT
username & passwords must match on both computers.
Yes (possible) and no (not recommandable).
-Yes: You can do this by choosing the same username and password on
both computers, the calling computer and the server. If you think now
"Well thats a bit weird...", I can acknowldge. The other possible
solution would be, if you use some programming language wich is able to
handle a security context, like C# with the appropiate classes, you
could impersonate the thread using the remote security context for
connecting.
-No: in common you cannot use integrated authentication across the
computers because the SQL Server can=B4t trust these unknown and
unreliable machines. Therefore a domain should be in place which can
guarantee with the user token for the real permissions of the user.
HTH, jens Suessmeyer.

possible to suppress DOS windowns in OSQL?

I just scanned the OSQL articles in BOL and I am not sure if there is a way to do this but I want to suppress the empty black DOS windows when calling my batch files that contain osql commands. Any ideas?I'd use the START command with the /MIN option.

-PatP|||... and additionally you can use /B option to control all in one window

Possible to setup SQL Mail w/o installing Outlook?

I just installed Windows 2003 Server and SQL Server 2000. I would like to
use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
profile in Outlook.
Is it possible to setup SQL Server Mail services without installing Outlook?
I remember in NT there was a mail icon in the Control Panel, this isn't
there anymore in 2003.
Thanks
ckanekoYou don't have to have Exchange, but it is my understanding to set up SQL
Mail you need have the Outlook client installed so you can create a mail
profile. Here is an article that might help:
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>|||Yes, you still need to install a MAPI client (eg Outlook 2003). If you don't wish to use a MAPI client and you only need to send mail take a look at xpsmtp. http://sqldev.net/xp/xpsmtp.htm|||Ive found that Outlook XP and 2003 wont work because they prompt the user
"Another application is trying to send email on behalf of you...do you want
to allow?" Maybe someone knows a way around this? So...I use Outlook 2000.
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>|||It's possible to get around this with the help of your Exchange
administrator (there's a link in the KB below)
INF: Common SQL Mail Problems
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q315886
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"JL Morrison" <jl_morrison@.hotmail.com> wrote in message
news:e9cVW%23dSEHA.3552@.TK2MSFTNGP09.phx.gbl...
> Ive found that Outlook XP and 2003 wont work because they prompt the user
> "Another application is trying to send email on behalf of you...do you
want
> to allow?" Maybe someone knows a way around this? So...I use Outlook
2000.
> "ckaneko" <ckaneko@.ffi-hq.com> wrote in message
> news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> > I just installed Windows 2003 Server and SQL Server 2000. I would like
to
> > use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a
mail
> > profile in Outlook.
> >
> > Is it possible to setup SQL Server Mail services without installing
> Outlook?
> > I remember in NT there was a mail icon in the Control Panel, this isn't
> > there anymore in 2003.
> >
> > Thanks
> > ckaneko
> >
> >
>|||Some options:
http://www.karaszi.com/sqlserver/info_no_mapi.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>

Possible to setup SQL Mail w/o installing Outlook?

I just installed Windows 2003 Server and SQL Server 2000. I would like to
use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
profile in Outlook.
Is it possible to setup SQL Server Mail services without installing Outlook?
I remember in NT there was a mail icon in the Control Panel, this isn't
there anymore in 2003.
Thanks
ckaneko
You don't have to have Exchange, but it is my understanding to set up SQL
Mail you need have the Outlook client installed so you can create a mail
profile. Here is an article that might help:
http://support.microsoft.com/default...b;en-us;263556
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>
|||Yes, you still need to install a MAPI client (eg Outlook 2003). If you don't wish to use a MAPI client and you only need to send mail take a look at xpsmtp. http://sqldev.net/xp/xpsmtp.htm
|||Ive found that Outlook XP and 2003 wont work because they prompt the user
"Another application is trying to send email on behalf of you...do you want
to allow?" Maybe someone knows a way around this? So...I use Outlook 2000.
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>
|||It's possible to get around this with the help of your Exchange
administrator (there's a link in the KB below)
INF: Common SQL Mail Problems
http://support.microsoft.com/default...;en-us;Q315886
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"JL Morrison" <jl_morrison@.hotmail.com> wrote in message
news:e9cVW%23dSEHA.3552@.TK2MSFTNGP09.phx.gbl...
> Ive found that Outlook XP and 2003 wont work because they prompt the user
> "Another application is trying to send email on behalf of you...do you
want
> to allow?" Maybe someone knows a way around this? So...I use Outlook
2000.[vbcol=seagreen]
> "ckaneko" <ckaneko@.ffi-hq.com> wrote in message
> news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
to[vbcol=seagreen]
mail
> Outlook?
>
|||Some options:
http://www.karaszi.com/sqlserver/info_no_mapi.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>

Possible to setup SQL Mail w/o installing Outlook?

I just installed Windows 2003 Server and SQL Server 2000. I would like to
use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
profile in Outlook.
Is it possible to setup SQL Server Mail services without installing Outlook?
I remember in NT there was a mail icon in the Control Panel, this isn't
there anymore in 2003.
Thanks
ckanekoYou don't have to have Exchange, but it is my understanding to set up SQL
Mail you need have the Outlook client installed so you can create a mail
profile. Here is an article that might help:
http://support.microsoft.com/defaul...kb;en-us;263556
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>|||Yes, you still need to install a MAPI client (eg Outlook 2003). If you don't wish to u
se a MAPI client and you only need to send mail take a look at xpsmtp. dev.net/xp/xpsmtp.htm" target="_blank">http://sql
dev.net/xp/xpsmtp.htm|||Ive found that Outlook XP and 2003 wont work because they prompt the user
"Another application is trying to send email on behalf of you...do you want
to allow?" Maybe someone knows a way around this? So...I use Outlook 2000.
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>|||It's possible to get around this with the help of your Exchange
administrator (there's a link in the KB below)
INF: Common SQL Mail Problems
http://support.microsoft.com/defaul...b;en-us;Q315886
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"JL Morrison" <jl_morrison@.hotmail.com> wrote in message
news:e9cVW%23dSEHA.3552@.TK2MSFTNGP09.phx.gbl...
> Ive found that Outlook XP and 2003 wont work because they prompt the user
> "Another application is trying to send email on behalf of you...do you
want
> to allow?" Maybe someone knows a way around this? So...I use Outlook
2000.
> "ckaneko" <ckaneko@.ffi-hq.com> wrote in message
> news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
to[vbcol=seagreen]
mail[vbcol=seagreen]
> Outlook?
>|||Some options:
http://www.karaszi.com/sqlserver/info_no_mapi.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl..
.
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing Outloo
k?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>

Possible to Export EM SQL Registrations?

I have a development laptop that I frequently need to reimage (ghost). I have about 25 SQL Servers registered in Enterprise Manager. Some use Windows Auth, some SQL Auth. Can I export the registration information so I don’t have to re-enter it every
time I rebuild my laptop?
I have been able to export/import the server aliases using this key (this works fine): [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer \Client\ConnectTo]
I have also exported/imported: [HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X]
But All I get are the groups, no servers.
TIA
Hi TIA,
I have noticed you posted another issue with topic "Export/Import SQL EM
Registrations?", I will add a reply to that thread. If you have any further
question, please post there and I will be glad to follow up
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Thanks, yea I got an error while posting... could not tell if the post wet through.
Thanks!
""Mingqing Cheng [MSFT]"" wrote:

> Hi TIA,
> I have noticed you posted another issue with topic "Export/Import SQL EM
> Registrations?", I will add a reply to that thread. If you have any further
> question, please post there and I will be glad to follow up
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Developer Community Support
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>

possible to connect to SQL Server Mobile database

Is it possible to have a Windows applications (based on .NET Framework 2.0) connect to a SQL Server Mobile database?

I manually added the the System.Data.SqlServerCe.dll (retrieved from C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\\SQL Server\Mobile\v3.0\System.Data.SqlServerCe.dll) to my Windows Form project. When I start the app, it gives me an error message:

{"Could not load file or assembly 'System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)":"System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"}

TIA

K. I got this to work.

My problem was that I did not reference the dll from the correct location. The correct location of the SqlServerCe dll to reference is "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\System.Data.SqlServerCe.dll"

|||

Thank god i found this, i tried what was said in

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

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

that didnt work for we, some how it worked for other ppl it seems.

anyway, Thanks

|||

Dear Stormin,

I took the dll from the right location as you specified. But now I get another error Unable to load DLL 'sqlceme30.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E).

|||

Hi all,

I have been searching for weeks now trying to solve the same problem. I wrote a desktop application- and I waqnt this desktop application to access a sdf database. The correct system.data.SqlServerCe.dll is correctly referenced and it still gives me a "Unable to load DLL 'sqlceme30.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)" error. If I can open the database from within the Dev environment and edit it from there, why can no one come up with a solution to this problem?

|||Have you installed the SQL CE runtime components on the machine? Have you tried to include all the SQL CE dlls with your app?|||

Copy all seven sqlce...dll files from C:\Program Files\Microsoft Visual Studio 8\Common7\IDE over to SYSTEM32 folder. This solved the problem for me. Check out the following link for details.

http://blogs.msdn.com/smartclientdata/archive/2005/07/15/439008.aspx

possible to connect to SQL Server Mobile database

Is it possible to have a Windows applications (based on .NET Framework 2.0) connect to a SQL Server Mobile database?

I manually added the the System.Data.SqlServerCe.dll (retrieved from C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\\SQL Server\Mobile\v3.0\System.Data.SqlServerCe.dll) to my Windows Form project. When I start the app, it gives me an error message:

{"Could not load file or assembly 'System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)":"System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"}

TIA

K. I got this to work.

My problem was that I did not reference the dll from the correct location. The correct location of the SqlServerCe dll to reference is "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\System.Data.SqlServerCe.dll"

|||

Thank god i found this, i tried what was said in

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

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

that didnt work for we, some how it worked for other ppl it seems.

anyway, Thanks

|||

Dear Stormin,

I took the dll from the right location as you specified. But now I get another error Unable to load DLL 'sqlceme30.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E).

|||

Hi all,

I have been searching for weeks now trying to solve the same problem. I wrote a desktop application- and I waqnt this desktop application to access a sdf database. The correct system.data.SqlServerCe.dll is correctly referenced and it still gives me a "Unable to load DLL 'sqlceme30.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)" error. If I can open the database from within the Dev environment and edit it from there, why can no one come up with a solution to this problem?

|||Have you installed the SQL CE runtime components on the machine? Have you tried to include all the SQL CE dlls with your app?|||

Copy all seven sqlce...dll files from C:\Program Files\Microsoft Visual Studio 8\Common7\IDE over to SYSTEM32 folder. This solved the problem for me. Check out the following link for details.

http://blogs.msdn.com/smartclientdata/archive/2005/07/15/439008.aspx

possible to connect to SQL Server Mobile database

Is it possible to have a Windows applications (based on .NET Framework 2.0) connect to a SQL Server Mobile database?

I manually added the the System.Data.SqlServerCe.dll (retrieved from C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\\SQL Server\Mobile\v3.0\System.Data.SqlServerCe.dll) to my Windows Form project. When I start the app, it gives me an error message:

{"Could not load file or assembly 'System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)":"System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"}

TIA

K. I got this to work.

My problem was that I did not reference the dll from the correct location. The correct location of the SqlServerCe dll to reference is "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\System.Data.SqlServerCe.dll"

|||

Thank god i found this, i tried what was said in

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

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

that didnt work for we, some how it worked for other ppl it seems.

anyway, Thanks

|||

Dear Stormin,

I took the dll from the right location as you specified. But now I get another error Unable to load DLL 'sqlceme30.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E).

|||

Hi all,

I have been searching for weeks now trying to solve the same problem. I wrote a desktop application- and I waqnt this desktop application to access a sdf database. The correct system.data.SqlServerCe.dll is correctly referenced and it still gives me a "Unable to load DLL 'sqlceme30.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)" error. If I can open the database from within the Dev environment and edit it from there, why can no one come up with a solution to this problem?

|||Have you installed the SQL CE runtime components on the machine? Have you tried to include all the SQL CE dlls with your app?|||

Copy all seven sqlce...dll files from C:\Program Files\Microsoft Visual Studio 8\Common7\IDE over to SYSTEM32 folder. This solved the problem for me. Check out the following link for details.

http://blogs.msdn.com/smartclientdata/archive/2005/07/15/439008.aspx

possible to connect to SQL Server Mobile database

Is it possible to have a Windows applications (based on .NET Framework 2.0) connect to a SQL Server Mobile database?

I manually added the the System.Data.SqlServerCe.dll (retrieved from C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\\SQL Server\Mobile\v3.0\System.Data.SqlServerCe.dll) to my Windows Form project. When I start the app, it gives me an error message:

{"Could not load file or assembly 'System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)":"System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"}

TIA

K. I got this to work.

My problem was that I did not reference the dll from the correct location. The correct location of the SqlServerCe dll to reference is "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\System.Data.SqlServerCe.dll"

|||

Thank god i found this, i tried what was said in

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

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

that didnt work for we, some how it worked for other ppl it seems.

anyway, Thanks

|||

Dear Stormin,

I took the dll from the right location as you specified. But now I get another error Unable to load DLL 'sqlceme30.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E).

|||

Hi all,

I have been searching for weeks now trying to solve the same problem. I wrote a desktop application- and I waqnt this desktop application to access a sdf database. The correct system.data.SqlServerCe.dll is correctly referenced and it still gives me a "Unable to load DLL 'sqlceme30.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)" error. If I can open the database from within the Dev environment and edit it from there, why can no one come up with a solution to this problem?

|||Have you installed the SQL CE runtime components on the machine? Have you tried to include all the SQL CE dlls with your app?|||

Copy all seven sqlce...dll files from C:\Program Files\Microsoft Visual Studio 8\Common7\IDE over to SYSTEM32 folder. This solved the problem for me. Check out the following link for details.

http://blogs.msdn.com/smartclientdata/archive/2005/07/15/439008.aspx

possible currupt database?

Hello everyone,
I recently moved a database from a Windows 2000 server (standard)
running SQL 2000 SP3 and placed it on a Windows 2003 server (standard) also
running SQL 2000 SP3. For some weird reason, on our citrix server which is
a BL20P (HP Blade) when my clients access their session and run the
application that is tied into the database that I just moved from one server
to the other, when they are prompted to either cancel or save their work, it
freezes and it doesn't save their work. Prior of moving this database, they
didn't have this problem, the other weird thing is, other people (normal
workstation computers) when they access the same program it works fine and
there are no hang ups. This program is a proprietary program that we use to
issue permits and it's made by HDL companies. I've had no luck with them
because they are pointing figures at me. My question, is it possible that
during the transportation of the database, and could it have been corrupted
during the process? Is there a way to do a consistency check on the
database? Help...
Thank you
Alex AndersonAlex,
Yes, there are tools to do consistency checks. Read about DBCC CHECKDB in
the BOL.
However, if your other non-HDL users are working, then I suspect the
database is probably not corrupted. I would suggest that you recheck the
security issues (grants, usernames, etc) that the HDL documentation should
specify. It may be that an account or account rights got missed during the
move.
Russell Fields
"Alex Anderson" <AAnderson@.Murrieta.org> wrote in message
news:uKw5$3cQEHA.132@.TK2MSFTNGP09.phx.gbl...
> Hello everyone,
> I recently moved a database from a Windows 2000 server (standard)
> running SQL 2000 SP3 and placed it on a Windows 2003 server (standard)
also
> running SQL 2000 SP3. For some weird reason, on our citrix server which
is
> a BL20P (HP Blade) when my clients access their session and run the
> application that is tied into the database that I just moved from one
server
> to the other, when they are prompted to either cancel or save their work,
it
> freezes and it doesn't save their work. Prior of moving this database,
they
> didn't have this problem, the other weird thing is, other people (normal
> workstation computers) when they access the same program it works fine and
> there are no hang ups. This program is a proprietary program that we use
to
> issue permits and it's made by HDL companies. I've had no luck with them
> because they are pointing figures at me. My question, is it possible
that
> during the transportation of the database, and could it have been
corrupted
> during the process? Is there a way to do a consistency check on the
> database? Help...
> Thank you
> Alex Anderson
>|||Russell,
Thank you for responding. I have logged in the same user that logs into
citrix where the problem exists on a workstation and that same user doesn't
have the problem. Security I have specified are two groups and there is
another SQL security user but that is for administration purposes. I'll
read up on DBCC and CHECKDB. It's the strangest problem I've ran into, and
I have everyone involved except Microsoft which would be my last ditch
effort.
Thank you
Alex Anderson
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:OmZCaGdQEHA.1392@.TK2MSFTNGP09.phx.gbl...
> Alex,
> Yes, there are tools to do consistency checks. Read about DBCC CHECKDB in
> the BOL.
> However, if your other non-HDL users are working, then I suspect the
> database is probably not corrupted. I would suggest that you recheck the
> security issues (grants, usernames, etc) that the HDL documentation should
> specify. It may be that an account or account rights got missed during
the
> move.
> Russell Fields
> "Alex Anderson" <AAnderson@.Murrieta.org> wrote in message
> news:uKw5$3cQEHA.132@.TK2MSFTNGP09.phx.gbl...
> also
> is
> server
work,[vbcol=seagreen]
> it
> they
and[vbcol=seagreen]
use[vbcol=seagreen]
> to
them[vbcol=seagreen]
> that
> corrupted
>

possible currupt database?

Hello everyone,
I recently moved a database from a Windows 2000 server (standard)
running SQL 2000 SP3 and placed it on a Windows 2003 server (standard) also
running SQL 2000 SP3. For some weird reason, on our citrix server which is
a BL20P (HP Blade) when my clients access their session and run the
application that is tied into the database that I just moved from one server
to the other, when they are prompted to either cancel or save their work, it
freezes and it doesn't save their work. Prior of moving this database, they
didn't have this problem, the other weird thing is, other people (normal
workstation computers) when they access the same program it works fine and
there are no hang ups. This program is a proprietary program that we use to
issue permits and it's made by HDL companies. I've had no luck with them
because they are pointing figures at me. My question, is it possible that
during the transportation of the database, and could it have been corrupted
during the process? Is there a way to do a consistency check on the
database? Help...
Thank you
Alex Anderson
Alex,
Yes, there are tools to do consistency checks. Read about DBCC CHECKDB in
the BOL.
However, if your other non-HDL users are working, then I suspect the
database is probably not corrupted. I would suggest that you recheck the
security issues (grants, usernames, etc) that the HDL documentation should
specify. It may be that an account or account rights got missed during the
move.
Russell Fields
"Alex Anderson" <AAnderson@.Murrieta.org> wrote in message
news:uKw5$3cQEHA.132@.TK2MSFTNGP09.phx.gbl...
> Hello everyone,
> I recently moved a database from a Windows 2000 server (standard)
> running SQL 2000 SP3 and placed it on a Windows 2003 server (standard)
also
> running SQL 2000 SP3. For some weird reason, on our citrix server which
is
> a BL20P (HP Blade) when my clients access their session and run the
> application that is tied into the database that I just moved from one
server
> to the other, when they are prompted to either cancel or save their work,
it
> freezes and it doesn't save their work. Prior of moving this database,
they
> didn't have this problem, the other weird thing is, other people (normal
> workstation computers) when they access the same program it works fine and
> there are no hang ups. This program is a proprietary program that we use
to
> issue permits and it's made by HDL companies. I've had no luck with them
> because they are pointing figures at me. My question, is it possible
that
> during the transportation of the database, and could it have been
corrupted
> during the process? Is there a way to do a consistency check on the
> database? Help...
> Thank you
> Alex Anderson
>
|||Russell,
Thank you for responding. I have logged in the same user that logs into
citrix where the problem exists on a workstation and that same user doesn't
have the problem. Security I have specified are two groups and there is
another SQL security user but that is for administration purposes. I'll
read up on DBCC and CHECKDB. It's the strangest problem I've ran into, and
I have everyone involved except Microsoft which would be my last ditch
effort.
Thank you
Alex Anderson
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:OmZCaGdQEHA.1392@.TK2MSFTNGP09.phx.gbl...
> Alex,
> Yes, there are tools to do consistency checks. Read about DBCC CHECKDB in
> the BOL.
> However, if your other non-HDL users are working, then I suspect the
> database is probably not corrupted. I would suggest that you recheck the
> security issues (grants, usernames, etc) that the HDL documentation should
> specify. It may be that an account or account rights got missed during
the[vbcol=seagreen]
> move.
> Russell Fields
> "Alex Anderson" <AAnderson@.Murrieta.org> wrote in message
> news:uKw5$3cQEHA.132@.TK2MSFTNGP09.phx.gbl...
> also
> is
> server
work,[vbcol=seagreen]
> it
> they
and[vbcol=seagreen]
use[vbcol=seagreen]
> to
them
> that
> corrupted
>

possible currupt database?

Hello everyone,
I recently moved a database from a Windows 2000 server (standard)
running SQL 2000 SP3 and placed it on a Windows 2003 server (standard) also
running SQL 2000 SP3. For some weird reason, on our citrix server which is
a BL20P (HP Blade) when my clients access their session and run the
application that is tied into the database that I just moved from one server
to the other, when they are prompted to either cancel or save their work, it
freezes and it doesn't save their work. Prior of moving this database, they
didn't have this problem, the other weird thing is, other people (normal
workstation computers) when they access the same program it works fine and
there are no hang ups. This program is a proprietary program that we use to
issue permits and it's made by HDL companies. I've had no luck with them
because they are pointing figures at me. My question, is it possible that
during the transportation of the database, and could it have been corrupted
during the process? Is there a way to do a consistency check on the
database? Help...
Thank you
Alex AndersonAlex,
Yes, there are tools to do consistency checks. Read about DBCC CHECKDB in
the BOL.
However, if your other non-HDL users are working, then I suspect the
database is probably not corrupted. I would suggest that you recheck the
security issues (grants, usernames, etc) that the HDL documentation should
specify. It may be that an account or account rights got missed during the
move.
Russell Fields
"Alex Anderson" <AAnderson@.Murrieta.org> wrote in message
news:uKw5$3cQEHA.132@.TK2MSFTNGP09.phx.gbl...
> Hello everyone,
> I recently moved a database from a Windows 2000 server (standard)
> running SQL 2000 SP3 and placed it on a Windows 2003 server (standard)
also
> running SQL 2000 SP3. For some weird reason, on our citrix server which
is
> a BL20P (HP Blade) when my clients access their session and run the
> application that is tied into the database that I just moved from one
server
> to the other, when they are prompted to either cancel or save their work,
it
> freezes and it doesn't save their work. Prior of moving this database,
they
> didn't have this problem, the other weird thing is, other people (normal
> workstation computers) when they access the same program it works fine and
> there are no hang ups. This program is a proprietary program that we use
to
> issue permits and it's made by HDL companies. I've had no luck with them
> because they are pointing figures at me. My question, is it possible
that
> during the transportation of the database, and could it have been
corrupted
> during the process? Is there a way to do a consistency check on the
> database? Help...
> Thank you
> Alex Anderson
>|||Russell,
Thank you for responding. I have logged in the same user that logs into
citrix where the problem exists on a workstation and that same user doesn't
have the problem. Security I have specified are two groups and there is
another SQL security user but that is for administration purposes. I'll
read up on DBCC and CHECKDB. It's the strangest problem I've ran into, and
I have everyone involved except Microsoft which would be my last ditch
effort.
Thank you
Alex Anderson
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:OmZCaGdQEHA.1392@.TK2MSFTNGP09.phx.gbl...
> Alex,
> Yes, there are tools to do consistency checks. Read about DBCC CHECKDB in
> the BOL.
> However, if your other non-HDL users are working, then I suspect the
> database is probably not corrupted. I would suggest that you recheck the
> security issues (grants, usernames, etc) that the HDL documentation should
> specify. It may be that an account or account rights got missed during
the
> move.
> Russell Fields
> "Alex Anderson" <AAnderson@.Murrieta.org> wrote in message
> news:uKw5$3cQEHA.132@.TK2MSFTNGP09.phx.gbl...
> > Hello everyone,
> >
> > I recently moved a database from a Windows 2000 server (standard)
> > running SQL 2000 SP3 and placed it on a Windows 2003 server (standard)
> also
> > running SQL 2000 SP3. For some weird reason, on our citrix server which
> is
> > a BL20P (HP Blade) when my clients access their session and run the
> > application that is tied into the database that I just moved from one
> server
> > to the other, when they are prompted to either cancel or save their
work,
> it
> > freezes and it doesn't save their work. Prior of moving this database,
> they
> > didn't have this problem, the other weird thing is, other people (normal
> > workstation computers) when they access the same program it works fine
and
> > there are no hang ups. This program is a proprietary program that we
use
> to
> > issue permits and it's made by HDL companies. I've had no luck with
them
> > because they are pointing figures at me. My question, is it possible
> that
> > during the transportation of the database, and could it have been
> corrupted
> > during the process? Is there a way to do a consistency check on the
> > database? Help...
> >
> > Thank you
> > Alex Anderson
> >
> >
>

Possible back door?

Hi I'm new to SQL and I've been asked to help my company with this server
(Windows 2003). Some history of what is going on is that the company is not
happy with their current tech situation and are in the process of getting
rid of their current tech and he knows it. This is where I come in like I
said have been asked to help with this situation. But I'm located at
different location so one of the first things the company wanted me to do is
setup an link between My loction and the other location using the internet.
So my first steps before opening up the the company was to try and secure th
e
system. But what I found is that the current tech is login in to the system
with an account called "sqlagentcmdexec" and on this account there is no
password (In my mind a big problem becauce I think this account was setup
with admin privileges). So when I was checking out the current user list and
their privileges this account in question was not there with all of the othe
r
accounts. I found a coulpe of articles that tells me a little about the
account but not a whole lot. So with all of that in mind what should I try t
o
do? Can I add a password to this account? Can I Find out what the account
privileges are and lower them if the are admin? If it is possible to lower
the account privileges what might be some of the side effects? Could there
be similar hiden accounts on this system and finally what would the best
thing to do in this situation?
Thank you for your time and help!What SQL Server version is used at this company?
I don't think such an account is created in the last two versions of SQL
Server : 2000 and 2005. It might be left from an older SQL Server
installation.
The following KB article has some information on this account:
http://support.microsoft.com/?id=264155
You could also ask for more information on the SQL Server Tools forum:
http://forums.microsoft.com/MSDN/Sh...ID=84&SiteID=1. You can
find answers about SQL Agent topics there.
Thanks
Laurentiu Cristofor [MSFT]
Software Design Engineer
SQL Server Engine
http://blogs.msdn.com/lcris/
This posting is provided "AS IS" with no warranties, and confers no rights.
"josh" <josh@.discussions.microsoft.com> wrote in message
news:F389E9E2-9716-4C26-8DC3-BADBFFFE810B@.microsoft.com...
> Hi I'm new to SQL and I've been asked to help my company with this server
> (Windows 2003). Some history of what is going on is that the company is
> not
> happy with their current tech situation and are in the process of getting
> rid of their current tech and he knows it. This is where I come in like I
> said have been asked to help with this situation. But I'm located at
> different location so one of the first things the company wanted me to do
> is
> setup an link between My loction and the other location using the
> internet.
> So my first steps before opening up the the company was to try and secure
> the
> system. But what I found is that the current tech is login in to the
> system
> with an account called "sqlagentcmdexec" and on this account there is no
> password (In my mind a big problem becauce I think this account was setup
> with admin privileges). So when I was checking out the current user list
> and
> their privileges this account in question was not there with all of the
> other
> accounts. I found a coulpe of articles that tells me a little about the
> account but not a whole lot. So with all of that in mind what should I try
> to
> do? Can I add a password to this account? Can I Find out what the account
> privileges are and lower them if the are admin? If it is possible to lower
> the account privileges what might be some of the side effects? Could
> there
> be similar hiden accounts on this system and finally what would the best
> thing to do in this situation?
> Thank you for your time and help!|||To add to Laurentiu's response, the local SqlAgentCmdExec account is created
during a SQL 7 install for use as the SQL Agent Proxy account. The password
should not be blank and is managed entirely by SQL Server. You can reset
the account password from Enterprise Manager per the article link Laurentiu
provided.
Hope this helps.
Dan Guzman
SQL Server MVP
"josh" <josh@.discussions.microsoft.com> wrote in message
news:F389E9E2-9716-4C26-8DC3-BADBFFFE810B@.microsoft.com...
> Hi I'm new to SQL and I've been asked to help my company with this server
> (Windows 2003). Some history of what is going on is that the company is
> not
> happy with their current tech situation and are in the process of getting
> rid of their current tech and he knows it. This is where I come in like I
> said have been asked to help with this situation. But I'm located at
> different location so one of the first things the company wanted me to do
> is
> setup an link between My loction and the other location using the
> internet.
> So my first steps before opening up the the company was to try and secure
> the
> system. But what I found is that the current tech is login in to the
> system
> with an account called "sqlagentcmdexec" and on this account there is no
> password (In my mind a big problem becauce I think this account was setup
> with admin privileges). So when I was checking out the current user list
> and
> their privileges this account in question was not there with all of the
> other
> accounts. I found a coulpe of articles that tells me a little about the
> account but not a whole lot. So with all of that in mind what should I try
> to
> do? Can I add a password to this account? Can I Find out what the account
> privileges are and lower them if the are admin? If it is possible to lower
> the account privileges what might be some of the side effects? Could
> there
> be similar hiden accounts on this system and finally what would the best
> thing to do in this situation?
> Thank you for your time and help!

Ports to open in Windows Firewall for SQL Server 2005

I'm running the Develpers version of SQL Server 2005 on my developer machine.
I want to test an application from another machine but can neither log on nor
use the SQL Server Management Studio from the remote machine unless I turn
off the Windows Firewall on the development machine. (I made sure to enable
remote connections via the Surface Configuration Tool too).
Though I seem to have the correct services listed in the "Exclusions" of the
Windows Firewall, I think that I should probably explicitly open the ports
that SQL Server and the Management Studio use. What are the correct ports or
is there a better way to work through the Windows Firewall. (This problem
should only exist in my development environment because I would not use the
Windows Firewall in a production setting on the Server)
Michael Hockstein
Did you also enable and start the sqlbrowser service?
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"michael" <howlinghound@.nospam.nospam> wrote in message
news:171212F6-D91C-4A02-AB42-23BEC0C325EB@.microsoft.com...
> I'm running the Develpers version of SQL Server 2005 on my developer
> machine.
> I want to test an application from another machine but can neither log on
> nor
> use the SQL Server Management Studio from the remote machine unless I turn
> off the Windows Firewall on the development machine. (I made sure to
> enable
> remote connections via the Surface Configuration Tool too).
> Though I seem to have the correct services listed in the "Exclusions" of
> the
> Windows Firewall, I think that I should probably explicitly open the ports
> that SQL Server and the Management Studio use. What are the correct ports
> or
> is there a better way to work through the Windows Firewall. (This problem
> should only exist in my development environment because I would not use
> the
> Windows Firewall in a production setting on the Server)
>
> --
> Michael Hockstein
|||Yes it is enabled and running. I can establish connections if I disable the
Windows Firewall on the machine with the SQL Server instance.
Michael Hockstein
"Roger Wolter[MSFT]" wrote:

> Did you also enable and start the sqlbrowser service?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "michael" <howlinghound@.nospam.nospam> wrote in message
> news:171212F6-D91C-4A02-AB42-23BEC0C325EB@.microsoft.com...
>
>
|||After a little searching, I thought that simple enabling port 1433 on the
server machine's fire wall would do the trick. It does allow connection to
the server for data exchange but it does not allow remote administration via
the SQL Server Management Studio. What additional port need to be opened to
allow this?
Michael Hockstein
"Roger Wolter[MSFT]" wrote:

> Did you also enable and start the sqlbrowser service?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "michael" <howlinghound@.nospam.nospam> wrote in message
> news:171212F6-D91C-4A02-AB42-23BEC0C325EB@.microsoft.com...
>
>
|||Hi there michael,
If your connecting fine to the database and it accepts data exchange,
perhaps you might look at the database permissions. Rather than any more
ports.
Opening 1433 within the firewall as far as im aware, is all you need for
admin.
Give the test account full sysadmin rights, and try that.
regards..
"michael" <howlinghound@.nospam.nospam> wrote in message
news:601836B2-038B-47C1-B1D5-99230963883A@.microsoft.com...[vbcol=seagreen]
> After a little searching, I thought that simple enabling port 1433 on the
> server machine's fire wall would do the trick. It does allow connection to
> the server for data exchange but it does not allow remote administration
> via
> the SQL Server Management Studio. What additional port need to be opened
> to
> allow this?
> --
> Michael Hockstein
>
> "Roger Wolter[MSFT]" wrote:
|||Hi Michael,
As Grumpy has mentioned, generally 1433 port is enough for connecting to
SQL server database engine. Also, for 2005, you can also try opening the
1434 UDP port since it will be used for establishing linked connection from
other applications. See the following article which describes the
"Connecting SQL Server over internet...":
Connecting to SQL Server over the Internet
http://msdn2.microsoft.com/en-us/library/ms175483.aspx
Regards,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
| From: "grumpy" <dtREMOVE2k@.blueTHISyonder.co.uk>
| Newsgroups: microsoft.public.sqlserver.connect
| References: <171212F6-D91C-4A02-AB42-23BEC0C325EB@.microsoft.com>
<#imE4XEJGHA.3904@.TK2MSFTNGP10.phx.gbl>
<601836B2-038B-47C1-B1D5-99230963883A@.microsoft.com>
| Subject: Re: Ports to open in Windows Firewall for SQL Server 2005
| Lines: 71
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| Message-ID: <x%dDf.11677$wl.6669@.text.news.blueyonder.co.uk>
| Date: Mon, 30 Jan 2006 01:31:09 GMT
| NNTP-Posting-Host: 82.42.42.142
| X-Complaints-To: abuse@.blueyonder.co.uk
| X-Trace: text.news.blueyonder.co.uk 1138584669 82.42.42.142 (Mon, 30 Jan
2006 01:31:09 GMT)
| NNTP-Posting-Date: Mon, 30 Jan 2006 01:31:09 GMT
| Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfee d00.sul.t-online.de!newsfe
ed01.sul.t-online.de!t-online.de!solnet.ch!solnet.ch!newsfeed.freenet.de! bor
der2.nntp.ams.giganews.com!border1.nntp.ams.gigane ws.com!nntp.giganews.com!p
e2.news.blueyonder.co.uk!blueyonder!pe1.news.bluey onder.co.uk!blueyonder!tex
t.news.blueyonder.co.uk!53ab2750!not-for-mail
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.connect:46765
| X-Tomcat-NG: microsoft.public.sqlserver.connect
|
| Hi there michael,
| If your connecting fine to the database and it accepts data exchange,
| perhaps you might look at the database permissions. Rather than any more
| ports.
|
| Opening 1433 within the firewall as far as im aware, is all you need for
| admin.
|
| Give the test account full sysadmin rights, and try that.
|
| regards..
|
| "michael" <howlinghound@.nospam.nospam> wrote in message
| news:601836B2-038B-47C1-B1D5-99230963883A@.microsoft.com...
| > After a little searching, I thought that simple enabling port 1433 on
the
| > server machine's fire wall would do the trick. It does allow connection
to
| > the server for data exchange but it does not allow remote
administration
| > via
| > the SQL Server Management Studio. What additional port need to be
opened
| > to
| > allow this?
| >
| > --
| > Michael Hockstein
| >
| >
| > "Roger Wolter[MSFT]" wrote:
| >
| >> Did you also enable and start the sqlbrowser service?
| >>
| >> --
| >> This posting is provided "AS IS" with no warranties, and confers no
| >> rights.
| >> Use of included script samples are subject to the terms specified at
| >> http://www.microsoft.com/info/cpyright.htm
| >>
| >> "michael" <howlinghound@.nospam.nospam> wrote in message
| >> news:171212F6-D91C-4A02-AB42-23BEC0C325EB@.microsoft.com...
| >> > I'm running the Develpers version of SQL Server 2005 on my developer
| >> > machine.
| >> > I want to test an application from another machine but can neither
log
| >> > on
| >> > nor
| >> > use the SQL Server Management Studio from the remote machine unless
I
| >> > turn
| >> > off the Windows Firewall on the development machine. (I made sure to
| >> > enable
| >> > remote connections via the Surface Configuration Tool too).
| >> >
| >> > Though I seem to have the correct services listed in the
"Exclusions"
| >> > of
| >> > the
| >> > Windows Firewall, I think that I should probably explicitly open the
| >> > ports
| >> > that SQL Server and the Management Studio use. What are the correct
| >> > ports
| >> > or
| >> > is there a better way to work through the Windows Firewall. (This
| >> > problem
| >> > should only exist in my development environment because I would not
use
| >> > the
| >> > Windows Firewall in a production setting on the Server)
| >> >
| >> >
| >> > --
| >> > Michael Hockstein
| >>
| >>
| >>
|
|
|
|||I meant is sqlbrowser enabled through the firewall.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"michael" <howlinghound@.nospam.nospam> wrote in message
news:D7E1B295-425A-47F9-9B9F-7E439508C1A9@.microsoft.com...[vbcol=seagreen]
> Yes it is enabled and running. I can establish connections if I disable
> the
> Windows Firewall on the machine with the SQL Server instance.
> --
> Michael Hockstein
>
> "Roger Wolter[MSFT]" wrote:
|||That's the trick! Enable the SQL Browser and Port 1433 in the Windows
Firewall and you get both connectivity and the ability to remotely
administer. Thanks!
Michael Hockstein
"Roger Wolter[MSFT]" wrote:

> I meant is sqlbrowser enabled through the firewall.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "michael" <howlinghound@.nospam.nospam> wrote in message
> news:D7E1B295-425A-47F9-9B9F-7E439508C1A9@.microsoft.com...
>
>