SQL server questions: local

Showing posts with label local. Show all posts

Tuesday, March 27, 2012

Able to connect via local host but not server

I have a page that connects to SQL server. It works fine when running in local host but when I publish to the server, I get the following:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Any ideas on where to start?

Thanks,

Mark

Try these two blog posts:

http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx

http://blogs.msdn.com/sql_protocols/archive/2005/10/29/486861.aspx

Saturday, February 25, 2012

a question for setup experts please

hello,
i have sql server 2000 on my local machine (with enterprise manager etc).
i want to host a website (on a dedicated server) which talks to sql server,
but i dont want to buy another license for the server machine that i am
going to host on (too much money!).
my question is:
is there a way around this? ie: is there a free engine or something that i
can install on my webserver which just stores the datafiles so my webpages
will work.
ideally i would like to DTS data to and from the live server, and also use
my local enterprise manager to view/update data on the live server?
is this possible?
thanksDepending on your requirements, you could deploy MSDE.
Not sure what this has to do with alt.photography though...
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"tracy" <tracyy@.spamfreenyf.com> wrote in message
news:GX9Xb.7063$ul3.1002@.news-binary.blueyonder.co.uk...
> hello,
> i have sql server 2000 on my local machine (with enterprise manager etc).
> i want to host a website (on a dedicated server) which talks to sql
server,
> but i dont want to buy another license for the server machine that i am
> going to host on (too much money!).
> my question is:
> is there a way around this? ie: is there a free engine or something that
i
> can install on my webserver which just stores the datafiles so my webpages
> will work.
> ideally i would like to DTS data to and from the live server, and also use
> my local enterprise manager to view/update data on the live server?
> is this possible?
> thanks
>|||lol, yeah the alt.photography was a bit of a mistake!
Can you tell me more about MSDE please, and whether it will meet my
requirements mentioned below.
Thanks.
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:OANb4um8DHA.2796@.TK2MSFTNGP09.phx.gbl...
> Depending on your requirements, you could deploy MSDE.
> Not sure what this has to do with alt.photography though...
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "tracy" <tracyy@.spamfreenyf.com> wrote in message
> news:GX9Xb.7063$ul3.1002@.news-binary.blueyonder.co.uk...
> > hello,
> >
> > i have sql server 2000 on my local machine (with enterprise manager
etc).
> >
> > i want to host a website (on a dedicated server) which talks to sql
> server,
> > but i dont want to buy another license for the server machine that i am
> > going to host on (too much money!).
> >
> > my question is:
> > is there a way around this? ie: is there a free engine or something
that
> i
> > can install on my webserver which just stores the datafiles so my
webpages
> > will work.
> >
> > ideally i would like to DTS data to and from the live server, and also
use
> > my local enterprise manager to view/update data on the live server?
> >
> > is this possible?
> >
> > thanks
> >
> >
>|||http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.asp
http://www.microsoft.com/sql/msde/
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"tracy" <tracyy@.spamfreenyf.com> wrote in message
news:r5aXb.7185$ul3.128@.news-binary.blueyonder.co.uk...
> lol, yeah the alt.photography was a bit of a mistake!
> Can you tell me more about MSDE please, and whether it will meet my
> requirements mentioned below.
> Thanks.
> "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> news:OANb4um8DHA.2796@.TK2MSFTNGP09.phx.gbl...
> > Depending on your requirements, you could deploy MSDE.
> >
> > Not sure what this has to do with alt.photography though...
> >
> > --
> > Aaron Bertrand
> > SQL Server MVP
> > http://www.aspfaq.com/
> >
> >
> >
> >
> > "tracy" <tracyy@.spamfreenyf.com> wrote in message
> > news:GX9Xb.7063$ul3.1002@.news-binary.blueyonder.co.uk...
> > > hello,
> > >
> > > i have sql server 2000 on my local machine (with enterprise manager
> etc).
> > >
> > > i want to host a website (on a dedicated server) which talks to sql
> > server,
> > > but i dont want to buy another license for the server machine that i
am
> > > going to host on (too much money!).
> > >
> > > my question is:
> > > is there a way around this? ie: is there a free engine or something
> that
> > i
> > > can install on my webserver which just stores the datafiles so my
> webpages
> > > will work.
> > >
> > > ideally i would like to DTS data to and from the live server, and also
> use
> > > my local enterprise manager to view/update data on the live server?
> > >
> > > is this possible?
> > >
> > > thanks
> > >
> > >
> >
> >
>|||You could also post specific questions to *just*
microsoft.public.sqlserver.msde
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"tracy" <tracyy@.spamfreenyf.com> wrote in message
news:r5aXb.7185$ul3.128@.news-binary.blueyonder.co.uk...
> lol, yeah the alt.photography was a bit of a mistake!
> Can you tell me more about MSDE please, and whether it will meet my
> requirements mentioned below.
> Thanks.
> "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> news:OANb4um8DHA.2796@.TK2MSFTNGP09.phx.gbl...
> > Depending on your requirements, you could deploy MSDE.
> >
> > Not sure what this has to do with alt.photography though...
> >
> > --
> > Aaron Bertrand
> > SQL Server MVP
> > http://www.aspfaq.com/
> >
> >
> >
> >
> > "tracy" <tracyy@.spamfreenyf.com> wrote in message
> > news:GX9Xb.7063$ul3.1002@.news-binary.blueyonder.co.uk...
> > > hello,
> > >
> > > i have sql server 2000 on my local machine (with enterprise manager
> etc).
> > >
> > > i want to host a website (on a dedicated server) which talks to sql
> > server,
> > > but i dont want to buy another license for the server machine that i
am
> > > going to host on (too much money!).
> > >
> > > my question is:
> > > is there a way around this? ie: is there a free engine or something
> that
> > i
> > > can install on my webserver which just stores the datafiles so my
> webpages
> > > will work.
> > >
> > > ideally i would like to DTS data to and from the live server, and also
> use
> > > my local enterprise manager to view/update data on the live server?
> > >
> > > is this possible?
> > >
> > > thanks
> > >
> > >
> >
> >
>

a question for setup experts please

Thursday, February 16, 2012

A problem in Distributed Transaction in a procedure

-- I made local procedure:

create procedure proc_AccountFrom
@.client varchar(50) = null
,@.account varchar(50) = null
,@.amount money = null
as

set nocount on

update client03.Northwind.dbo.ClientAccount
set AccountAmount = AccountAmount - @.amount
where ClientName = @.client and AccountName = @.account

-- I also made a procedure on the server:

create procedure proc_AccountTo
@.client varchar(50) = null
,@.account varchar(50) = null
,@.amount money = null
as

set nocount on

update server01.Northwind.dbo.ClientAccount
set AccountAmount = AccountAmount + @.amount
where ClientName = @.client and AccountName = @.account

set nocount off

-- I made the following local procedure:

create procedure proc_AccountTransfer
@.client varchar(50) = null
,@.account varchar(50) = null
,@.amount money = null
as
set nocount on
set ansi_warnings on
set xact_abort on

begin distributed transaction

exec proc_AccountFrom 'Bishoy','Saving',1000

exec server01.Northwind.dbo.proc_AccountTo 'Bishoy','Saving',1000

commit transaction

-- The table code:

use northwind
go
CREATE TABLE [dbo].[ClientAccount]
(ClientID int IDENTITY (1,1) NOT NULL
,ClientName varchar (50) NOT NULL
,AccountName varchar (50) NOT NULL
,AccountAmount money NOT NULL
,constraint PK_ClientID primary key clustered (ClientID)
,constraint CK_Amount check (AccountAmount >= 0)
)
go
insert into dbo.ClientAccount values ('Bishoy','Checking',100000)
insert into dbo.ClientAccount values ('Bishoy','Saving',2000)
go

\r\n

-- But I received the following response:

\r\n

Server: Msg 7391, Level 16, State 1, Procedure proc_AccountTransfer, Line 12
The operation could not be performed because the OLE DB provider \'SQLOLEDB\' was unable to begin a distributed transaction. \r\n
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider \'SQLOLEDB\' ITransactionJoin::JoinTransacti on returned 0x8004d00a]. \r\n
?

\r\n

-- Although:

\r\n

The DTS was active on both servers ?-- ?and they was linked?

\r\n

--? and the tables present

\r\n

--
Thank you.
Bishoy

\r\n\r\n",0]);D(["ce"]);D(["ms","1f76"]);//-->

-- But I received the following response:

Server: Msg 7391, Level 16, State 1, Procedure proc_AccountTransfer, Line 12
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransacti on returned 0x8004d00a].

-- Although:

The DTS was active on both servers -- and they was linked

-- and the tables present

By 'DTS' do you mean 'DTC'? The MSDTC to be precise?
First off, make sure that the DTC process is running on both systems. Second, make sure that Network DTC Access is checked on both systems.
Hope that helps.
|||Can have multiple causes, but first check your firewall, you'll have to insert a rule in it (or turn it of :s)
|||Yes, DTC was running on both servers.
But, how to make sure that Network DTC Access is checked on both systems?

A new member could not be added to a local group because the member has the wrong account type

Hi all,

I installed SQL 2005 SP2 + ReportServices Add-in for Sharepoint (WSS 3.0). All it's OK until I try to grant database access in the Sharepoint Central Admin site.

I setup the Reporting Services Integration (Manage integration settings). I use the default SQL instance, I put the USERNAME and the PASSWORD of my ADMIN account in the ENTER CREDENTIALS windows.. When I click the "OK" button, I receive always the error ...

"A new member could not be added to a local group because the member has the wrong account type"

I tried a lot of things... without success.

Is there someone who can help me....

PS: There is no error in the LOG

Thanks

I am also having this same issue. I cannot seem to find any help for this out there by Google search or otherwise. I've seen some blip about installing on a domain controller. Please help.|||I discovered a workaround. I used the IP address of the DBMS instead of the local computer name. Then I used the DOMAINNAME\SP_Setup_User (or admin) account and password. This worked. Hopefully no ill effects.|||

Unfortunately, this approach didn't work for me. If any other idea, please let me know.

Thanks

|||

Erik,

I came to the conclusion to use the IP address of the SQL Server instead of the name because, you know how you want to map a drive to the same server using two different user accounts? Well, you have to use the server name for one mapping and then something else for the second mapping, like the IP address. It probably has nothing to do with this problem, but it reminded me of it. So it did work, at least on my system. Again, I do not know if there are any obscure consequences of doing this. So far all is well. Maybe there is a Microsoft person listening in or someone who could lend some thoughts to the situation for you.

Mike

|||

Hi Guys, had the same problem. Tried with IP address and yes it worked. However, when I went into Visual Studio and created a report when I went to deploy it a username/password form pops up. No matter what username/password is inserted can't get it to deploy. Any help would be greatly appreciated.

Keith

|||

Try using Fully Qualified domain Name of the SQL Server..

and It Works!..

|||

do you mean servername\username & password because it did not work. I enterede servername/username in the reporting services UI and then went into visual studio to deploy (on same machine) but when I went to deploy you would enter servername/username and it would just keep poping up and never do anything.

Any thing to look at for the account. I have tried a user account and on last atempt I used administrator, but no luck.

Thanks for any help!

|||

I have done some more work on it and in sharepoint central administration, reporting services, manage integration services, set to windows account. and it all saves with out complaing. Now when I gointo Visual studio on the same machine as reporting service and sharepoint I no longer get a log in box but I get "a connection could not be made to the report server... this operation is not supported on a report server that is configured to run in sharepoint integration...

anybody and thoughts?

Thanks

|||

did some more work/investigation and I stumbled into that if you go the sharepoint site, document library and try to add the new document type of reporting services, it does not show up in the list. So I think everything deployed okay but it appears there is no link between sharepoint and report services. Also incase this helps, sharepoint is not in the default website, but is it's own web site that instead of www we have companyweb. Other that reporting services sharpoint works fine.

Help!

|||

Keith,

Our report server web service is at http://{Report Server servername}:8080/ReportServer2K5, port 8080 being the new port of the re-enabled IIS default web site. However, the deployment properties for the VS 2005 report project actually had to be set like so: (1) TargetDataSourceFolder and TargetReportFolder = http://{SharePoint servername}:{Admin Site Port Number}/{Our Report Library Name}/, and (2) TargetServerURL = http://{SharePoint servername}:{Admin Site Port Number}/. I can deploy right from Visual Studio with this configuration. The account used for the Windows service identity is the same as that used for SharePoint administration in my case. There are a myriad of possible combinations for these accounts, though.

Mike

A new member could not be added to a local group because the member has the wrong account type

Hi all,

I installed SQL 2005 SP2 + ReportServices Add-in for Sharepoint (WSS 3.0). All it's OK until I try to grant database access in the Sharepoint Central Admin site.

"A new member could not be added to a local group because the member has the wrong account type"

I tried a lot of things... without success.

Is there someone who can help me....

PS: There is no error in the LOG

Thanks

Unfortunately, this approach didn't work for me. If any other idea, please let me know.

Thanks

|||

Erik,

Mike

|||

Keith

|||

Try using Fully Qualified domain Name of the SQL Server..

and It Works!..

|||

Any thing to look at for the account. I have tried a user account and on last atempt I used administrator, but no luck.

Thanks for any help!

|||

anybody and thoughts?

Thanks

|||

Help!

|||

Keith,

Mike

Monday, February 13, 2012

A new member could not be added to a local group because the member has the wrong account type

Hi all,

I installed SQL 2005 SP2 + ReportServices Add-in for Sharepoint (WSS 3.0). All it's OK until I try to grant database access in the Sharepoint Central Admin site.

"A new member could not be added to a local group because the member has the wrong account type"

I tried a lot of things... without success.

Is there someone who can help me....

PS: There is no error in the LOG

Thanks

Hi Did anyone have a resolution to this situation. We're getting the same error message following the same sequence of events. Any assistance is appreciated.

|||

No... nothing... niet...

If you find any info, let me know please.

|||

Anybody find anything on this? I'm getting same error|||

I'm getting the same frustrating error. Any news on a solution?

Thanks!

A new member could not be added to a local group because the member has the wrong account type

Hi all,

I installed SQL 2005 SP2 + ReportServices Add-in for Sharepoint (WSS 3.0). All it's OK until I try to grant database access in the Sharepoint Central Admin site.

"A new member could not be added to a local group because the member has the wrong account type"

I tried a lot of things... without success.

Is there someone who can help me....

PS: There is no error in the LOG

Thanks

Hi Did anyone have a resolution to this situation. We're getting the same error message following the same sequence of events. Any assistance is appreciated.

|||

No... nothing... niet...

If you find any info, let me know please.

|||

Anybody find anything on this? I'm getting same error|||

I'm getting the same frustrating error. Any news on a solution?

Thanks!

A new member could not be added to a local group because the member has the wrong account type

Hi all,

I installed SQL 2005 SP2 + ReportServices Add-in for Sharepoint (WSS 3.0). All it's OK until I try to grant database access in the Sharepoint Central Admin site.

"A new member could not be added to a local group because the member has the wrong account type"

I tried a lot of things... without success.

Is there someone who can help me....

PS: There is no error in the LOG

Thanks

Hi Did anyone have a resolution to this situation. We're getting the same error message following the same sequence of events. Any assistance is appreciated.|||

No... nothing... niet...

If you find any info, let me know please.

|||Anybody find anything on this? I'm getting same error|||

I'm getting the same frustrating error. Any news on a solution?

Thanks!

A new member could not be added to a local group because the member has the wrong account type

Hi all,

I installed SQL 2005 SP2 + ReportServices Add-in for Sharepoint (WSS 3.0). All it's OK until I try to grant database access in the Sharepoint Central Admin site.

"A new member could not be added to a local group because the member has the wrong account type"

I tried a lot of things... without success.

Is there someone who can help me....

PS: There is no error in the LOG

Thanks

Hi Did anyone have a resolution to this situation. We're getting the same error message following the same sequence of events. Any assistance is appreciated.|||

No... nothing... niet...

If you find any info, let me know please.

|||Anybody find anything on this? I'm getting same error|||

I'm getting the same frustrating error. Any news on a solution?

Thanks!

A new member could not be added to a local group because the member has the wrong account type

Hi all,

I installed SQL 2005 SP2 + ReportServices Add-in for Sharepoint (WSS 3.0). All it's OK until I try to grant database access in the Sharepoint Central Admin site.

"A new member could not be added to a local group because the member has the wrong account type"

I tried a lot of things... without success.

Is there someone who can help me....

PS: There is no error in the LOG

Thanks

Unfortunately, this approach didn't work for me. If any other idea, please let me know.

Thanks

|||

Erik,

Mike

|||

Keith

|||

Try using Fully Qualified domain Name of the SQL Server..

and It Works!..

|||

Any thing to look at for the account. I have tried a user account and on last atempt I used administrator, but no luck.

Thanks for any help!

|||

anybody and thoughts?

Thanks

|||

Help!

|||

Keith,

Mike

Thursday, February 9, 2012

A few things to do with store variables.

Okay,

I'm creating a small application for my local school district that will allow them to do a small management of inventory.

OPTIONS

username

password

Could someone please help me with this..... If it's in the wrong forum please let me know.

Thanks,

QWERTYtech

What kind of database does your program use? Full SQL Server, SQL Server Express, Access, or other?|||SQL Express|||

Move the thread from Visual Basic General. There are more exports on storing variables in SQL Express database. I believe you can get satisfying answers in this forum.

Thanks again for your question.

|||

Perhaps these sources will help:

SQL Server 2005 UnAttended Installations
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
http://msdn2.microsoft.com/en-us/library/bb264562.aspx
http://www.devx.com/dbzone/Article/31648

Tuesday, March 27, 2012

Able to connect via local host but not server

Saturday, February 25, 2012

a question for setup experts please

a question for setup experts please

a question for setup experts please

Thursday, February 16, 2012

A problem in Distributed Transaction in a procedure

A new member could not be added to a local group because the member has the wrong account type

A new member could not be added to a local group because the member has the wrong account type

Monday, February 13, 2012

A new member could not be added to a local group because the member has the wrong account type

A new member could not be added to a local group because the member has the wrong account type

A new member could not be added to a local group because the member has the wrong account type

A new member could not be added to a local group because the member has the wrong account type

A new member could not be added to a local group because the member has the wrong account type

Thursday, February 9, 2012

A few things to do with store variables.

SQL server questions

Blog Archive

About Me