Can not connect to SQL Server 2005 Developer edition remotely

I setup a SQL Server 2005 Developer edition, which is bundled with Visual Studio .NET 2005 Professional edition. The SQL Server authentication mode is enabled in this database server. But when I try to connect it from another PC using SQL Server authentication, it failed. Is it a limitation on the developer edition?

Hi,

although you didn′t post the erro rmessage, I assume that remote connectivity is not enabled, change the remote flag which can be see in this screen:

http://www.sqlserver2005.de/SharedFiles/Remoteconnection.jpg

HTH, jens suessmeyer.

http://www.sqlserver2005.de

|||

Hi,

I still can't login remotely to the server, the error message is:

Cannot connect to 137.xxx.xx.xx\STD2005
error: 26 - Error Locating Sever/Instance Specified

I setup a MSSQL Server 2005 Standard edition on a remote computer 137.xxx.xx.xx (I'm sure the network has no any problem, since this remote computer has a SQL2000 server that I can use the Enterprise Manager in my PC to connect to it), and the named instance called STD2005. I try to connect to it through the Management Studio in my PC, using the sa account and one acccount that I created before, both not work. Any idea?

|||Hi,

so you are usinga named instance. I assume you didn′t put the named instance on the defaulport, which is as a default used to connect to a sql server instance. If the named instances has another port you have to specify it with the syntax:

Servername\InstanceName,Portnumber

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||Also: Can we rule out a firewall problem? Is the SQL Browser service running on the server machine?

Best,
Nils Loeber
|||

In SQL 2005 Developer Edition TCP\IP is disabled by default. You can go to Server Configuration and enable it. I hope that helps.

JB

Can not connect to SQL server 2000 on windows authentication mode

Hello everyone,

We have SQL server 2000 on windows 2000. From our desktop MS Access was connected to database through ODBC. Since yesterday (after our consultant had updated another asp application in the same server) we are getting “SQL Server Error: 18452. ….. Login failed for user ‘(null)’. Reason: not associated with a trusted SQL Server connection. “

The consultant saying he did not touch any settings on server (?). And the problem is even server’s security property shows it has mixed mode authentication. But I cannot connect to server even through my SQL server enterprise manager in windows authentication mode. I can connect if I use SQL server authentication. Through ODBC I can connect also and test fine, if I use SQL authentication. But the Access application wouldn’t connect using SQL authentication in ODBC.

So, can any one help me to find out what else could be done to make sure that the server is going to accept windows authentication. I’m thinking any other settings or registry change … etc. Please help.

Thanks

You are getting the error during the communication with the Web Servcie, right ? Then you probably changed the Security of the ASP application to not allow Integrated authentication. Are you using an asp or an ASP.nET application ?

HTH, jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Hi Jens,

No our web service is fine. We are trying to connect through ODBC and SQL enterprise manager.

|||

Hi Taposh,

Did any of the security settings on the SQL Server itself changed? (ie. was some Windows user account access removed from SQL security settings?) You can verify this by using Enterprise manager and login using "sa" and expand the server; expand Security, and then click Logins.

Unfortunately, there are a few scenarios in which you will receive an 18452 error back from the server. Some of the typical scenarios include; missing login rights for Windows users; client and server on different domains (Kerberos trust issue).

Please have a look at http://blogs.msdn.com/sql_protocols/archive/2006/12/02/understanding-kerberos-and-ntlm-authentication-in-sql-server-connections.aspx

I would also recommend searching on the web using the error message as the key phrase.

HTH,
Jimmy

Can not connect to MS SQL server

Hi I have problems with connecting to MS SQL server.

SQL server is configured to log in with Windows Authentication mode.

The only thing I need is to configure the web.config.

My configuration in web.config-file is as follow:

<appSettings>

<addkey="forumDSN"value="server=localhost;uid=;pwd=;database=forum"/>

</appSettings>

I get the following message afte running my ASP page:

Exception Details:System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.

HELP please.

Is the SQL Server on the same machine as the Web server? In the real Web.Config, to you provide an actual uid and password?|||

Hey hi,

1st u check out wheter the sql server whichs running has got any name...coz, some times the local host is not taken as the default instead, its named with some name.

to check that, just open the sql server service manager, there u can C Server :"........"

that name should be used.

also for further details go through the following link

http://www.functionx.com/sqlserver/Lesson01.htm

also the this one for the security issues

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetch12.asp

hope this helps

all the best

|||

yes, It is in the same machine running WindowsXP

thanks

sql

Can not attach mdf 2005 file into sqlserver 2000

hello all.
I have a database file in sqlserver 2005 mode, i set it's compatiblity to sqlserver 2000 (80) but i cant attach it in sqlserver 2000.
My host only support sqlserver 2000!

I need any help to convert or attach it!
Thank all!

Sadly to say: you can not attach a SQL2005 database to a SQL2000 instance even you set the compatiblity to sqlserver 2000 (80). I'm afraid you have create a new database with exact the same schema in SQL2000, and transfer data from the original database to the new one. You can get the scripts for creating the objects of the same schemas by right clicking the objects in Management Studio.

|||

Thank!

Sql 2005 is so bad! No server is using it now!

Can I Use ADOMD or AMO In ASP.NET 2.0

Hi~

I know some function can be used in debug mode,like MsgBox()...,in ASP.NET 2.0.

But I don't know that Can ADOMD or AMO be used in ASP.NET 2.0.

Could someone tell me?

thanks~

Server: SQL Server 2005

OS: Windows 2003

Yes you can use both ADOMD and AMO from ASP.NET. The main "trick" is to get the code executing as a user that has the approriate rights to access the required SSAS objects. Setting up your application pool up to run under a domain account that is in appropriate SSAS roles is one way of getting this to work.

Can I run the SQL Server 2005 Developer Edition in Standard Edition Mode?

As an ISV, I want to certify my product on Standard Edition. I am using Developer Edition everywhere. Is there a way I can do the certification using the Developer Edition, or do I need to obtain/purchase a copy of the Standard Edition?

I think you're asking if there's some way to temporarily turn off features in the Dev Edition that aren't available in the Standard Edition. That's an interesting idea but it's not something we support directly in SQL Server 2005. To absolutely insure that you didn't include any non-STD features in your app or to get precise STD performance/footprint characteristics, I guess you need a copy of STD.

Paul

|||

>> I guess you need a copy of STD.

Which Sexually Transmitted Disease does he need? (That's the common meaning of the acronym STD).

It may be a bit too late now, but fwiw, everybody who attended the VS.2005 product launch (in November 2005) came away with a real licensed copy of SQL Server 2005 Standard Edition. If you know of someone who was there, perhaps you can persuade them to clap a copy into your hands.

Josh

Can I run the SQL Server 2005 Developer Edition in Standard Edition Mode?

As an ISV, I want to certify my product on Standard Edition. I am using Developer Edition everywhere. Is there a way I can do the certification using the Developer Edition, or do I need to obtain/purchase a copy of the Standard Edition?

I think you're asking if there's some way to temporarily turn off features in the Dev Edition that aren't available in the Standard Edition. That's an interesting idea but it's not something we support directly in SQL Server 2005. To absolutely insure that you didn't include any non-STD features in your app or to get precise STD performance/footprint characteristics, I guess you need a copy of STD.

Paul

|||

>> I guess you need a copy of STD.

Which Sexually Transmitted Disease does he need? (That's the common meaning of the acronym STD).

It may be a bit too late now, but fwiw, everybody who attended the VS.2005 product launch (in November 2005) came away with a real licensed copy of SQL Server 2005 Standard Edition. If you know of someone who was there, perhaps you can persuade them to clap a copy into your hands.

Josh

Can I run the SQL Server 2005 Developer Edition in Standard Edition Mode?

As an ISV, I want to certify my product on Standard Edition. I am using Developer Edition everywhere. Is there a way I can do the certification using the Developer Edition, or do I need to obtain/purchase a copy of the Standard Edition?

I think you're asking if there's some way to temporarily turn off features in the Dev Edition that aren't available in the Standard Edition. That's an interesting idea but it's not something we support directly in SQL Server 2005. To absolutely insure that you didn't include any non-STD features in your app or to get precise STD performance/footprint characteristics, I guess you need a copy of STD.

Paul

|||

>> I guess you need a copy of STD.

Which Sexually Transmitted Disease does he need? (That's the common meaning of the acronym STD).

It may be a bit too late now, but fwiw, everybody who attended the VS.2005 product launch (in November 2005) came away with a real licensed copy of SQL Server 2005 Standard Edition. If you know of someone who was there, perhaps you can persuade them to clap a copy into your hands.

Josh

Can I restore Master using SQL LiteSpeed?

I'm trying to restore master using a backup that was created using SQL Lightspeed. The server will start in single user mode but when I try to restore master I get a login failure. I receive this using query analyzer. I can not restore using enterprise
manager because the master.bak file was generated using litespeed. Any Ideas?
Thank you.
Message posted via http://www.sqlmonster.com
Hi,
I believe there is a free LiteSpeed utility that will convert your backup
file to a standard Microsoft SQL backup file. You might be able to
successfully use this.
Joe
"Chris via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:d7a80756b65e4506b6d7d770a49f69cb@.SQLMonster.c om...
> I'm trying to restore master using a backup that was created using SQL
> Lightspeed. The server will start in single user mode but when I try to
> restore master I get a login failure. I receive this using query
> analyzer. I can not restore using enterprise manager because the
> master.bak file was generated using litespeed. Any Ideas?
> Thank you.
> --
> Message posted via http://www.sqlmonster.com
|||Chris via SQLMonster.com wrote:
> I'm trying to restore master using a backup that was created using
> SQL Lightspeed. The server will start in single user mode but when I
> try to restore master I get a login failure. I receive this using
> query analyzer. I can not restore using enterprise manager because
> the master.bak file was generated using litespeed. Any Ideas?
> Thank you.
Please contact our support department for help on this issue:
https://www.imceda.com/support.asp
David Gugick
Imceda Software
www.imceda.com

Can I restore Master using SQL LiteSpeed?

I'm trying to restore master using a backup that was created using SQL Light
speed. The server will start in single user mode but when I try to restore
master I get a login failure. I receive this using query analyzer. I can n
ot restore using enterprise
manager because the master.bak file was generated using litespeed. Any Idea
s?
Thank you.
Message posted via http://www.droptable.comHi,
I believe there is a free LiteSpeed utility that will convert your backup
file to a standard Microsoft SQL backup file. You might be able to
successfully use this.
Joe
"Chris via droptable.com" <forum@.droptable.com> wrote in message
news:d7a80756b65e4506b6d7d770a49f69cb@.SQ
droptable.com...
> I'm trying to restore master using a backup that was created using SQL
> Lightspeed. The server will start in single user mode but when I try to
> restore master I get a login failure. I receive this using query
> analyzer. I can not restore using enterprise manager because the
> master.bak file was generated using litespeed. Any Ideas?
> Thank you.
> --
> Message posted via http://www.droptable.com|||Chris via droptable.com wrote:
> I'm trying to restore master using a backup that was created using
> SQL Lightspeed. The server will start in single user mode but when I
> try to restore master I get a login failure. I receive this using
> query analyzer. I can not restore using enterprise manager because
> the master.bak file was generated using litespeed. Any Ideas?
> Thank you.
Please contact our support department for help on this issue:
https://www.imceda.com/support.asp
David Gugick
Imceda Software
www.imceda.com

Can I restore Master using SQL LiteSpeed?

I'm trying to restore master using a backup that was created using SQL Lightspeed. The server will start in single user mode but when I try to restore master I get a login failure. I receive this using query analyzer. I can not restore using enterprise manager because the master.bak file was generated using litespeed. Any Ideas?
Thank you.
--
Message posted via http://www.sqlmonster.comHi,
I believe there is a free LiteSpeed utility that will convert your backup
file to a standard Microsoft SQL backup file. You might be able to
successfully use this.
Joe
"Chris via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:d7a80756b65e4506b6d7d770a49f69cb@.SQLMonster.com...
> I'm trying to restore master using a backup that was created using SQL
> Lightspeed. The server will start in single user mode but when I try to
> restore master I get a login failure. I receive this using query
> analyzer. I can not restore using enterprise manager because the
> master.bak file was generated using litespeed. Any Ideas?
> Thank you.
> --
> Message posted via http://www.sqlmonster.com|||Chris via SQLMonster.com wrote:
> I'm trying to restore master using a backup that was created using
> SQL Lightspeed. The server will start in single user mode but when I
> try to restore master I get a login failure. I receive this using
> query analyzer. I can not restore using enterprise manager because
> the master.bak file was generated using litespeed. Any Ideas?
> Thank you.
Please contact our support department for help on this issue:
https://www.imceda.com/support.asp
David Gugick
Imceda Software
www.imceda.com

Can I limit 'detail' rows per page?

Is there a way from the report designer, in layout mode, to set a limit
of rows to, let's say 5 per page?
Thanks,
TrintHello, I would like to do the same thing. For example, I would like to create an invoice template and have a header section contain the Billto, Shipto addresses and a footer section contain the remittance section. However, the middle of the 'page' should have a fixed number of records for the detail items on the invoice. If more than the fixed amount of detail records is reached, a second page would be displayed. Any help or insight with this would be helpful. Thanks, Dave
--
Message posted via http://www.sqlmonster.com|||Add a group to your table, set the group expression to
=System.Math.Floor((RowNumber(Nothing)-1)/<# of rows you want to display in
a page>, and turn on page break on the group. The header and footer sections
would be the group header and footer, and you can mark them repeated on new
page.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dave C via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:c5d891b35fa44feeaef5957179524cdc@.SQLMonster.com...
> Hello, I would like to do the same thing. For example, I would like to
create an invoice template and have a header section contain the Billto,
Shipto addresses and a footer section contain the remittance section.
However, the middle of the 'page' should have a fixed number of records for
the detail items on the invoice. If more than the fixed amount of detail
records is reached, a second page would be displayed. Any help or insight
with this would be helpful. Thanks, Dave
> --
> Message posted via http://www.sqlmonster.com