Showing posts with label web. Show all posts

Friday, March 30, 2012

Microsoft SQL Server client license costs

I have three questions: Could anyone help.
1. How much does a Microsoft SQL Server client license cost?
2. If we have web interface as the front end and SQL server as the back end,
do we need client licenses for those accessing their databases via the web?
3. Also if we have people accessing the server with Access,do we need
licenses for those?
"bgm" <bgm@.discussions.microsoft.com> wrote in message
news:17913AFE-A04D-47B3-96A7-C4216A68E6D8@.microsoft.com...
> I have three questions: Could anyone help.
> 1. How much does a Microsoft SQL Server client license cost?
http://www.microsoft.com/sql/howtobuy/default.asp

> 2. If we have web interface as the front end and SQL server as the back
end,
> do we need client licenses for those accessing their databases via the
web?
It's better to buy a per-processor licence because you do not know the
number of users (or you have developed a database access componenet and you
need to limit the number of concurrent users).

> 3. Also if we have people accessing the server with Access,do we need
> licenses for those?
It's an extra connection.
|||>> 2. If we have web interface as the front end and SQL server as the back
> end,
> web?
> It's better to buy a per-processor licence because you do not know the
> number of users (or you have developed a database access componenet and
> you
> need to limit the number of concurrent users).
the only option is per processor license! You can't use per user connection
license.

Microsoft SQL Server client license costs

I have three questions here:Could anyone help.
1.How much does a Microsoft SQL Server client license cost?
2.If we have web interface as the front end and SQL server as the back
end,do we need client licenses for those accessing the databases via the web?
3.If we have people accessing the server with Access,do we need licenses for
those?
Hi,
You can check the following whitepaper and article for information on SQL
Server licensing and prices
http://www.microsoft.com/sql/howtobu...licensing.asp.
http://www.microsoft.com/sql/howtobuy/faq.asp
You can also call (800) 426-9400 to clarify your doubts on the licensing.
Regards,
Gayathri Rau [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
sql

Microsoft SQL Server 2005 performance

Hi,

I have a Microsoft SQL Server 2005 Enterprise installed on Windows Server 2003, and developing web application for 500 clients. So I am interested will I have any performance issues if I put in 'Articles' table, data for all 500 clients and then filter it on client ID, or should I make 500 'Articles' tables for every client one with different name and then change sqldatasource for gridview depending on which client is working on it. I will have, beside 'Articles' table, another 10 tables, which means 5500 tables total, if I use second approach, on first I will have only 11 tables. So I am asking is it better to have more tables with less data, or less tables with more data. And what are pros and cons for both approach.

Thanks a lot!

One table with different ArticleIDs is the way it should be. With proper indexes you should just be fine.

Microsoft SQL Server 2005 Express Edition Service Pack 2 ..Failure

Windows Update Web Page indicates I have BOTH a
SUCCESS and FAILURE for
SQL Server 2005 Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896)
?Is it possible for my machine to have TWO DIFFERENT MS SQL Server Express installations? Is the problem real or some small ghost issue?
I do have a trial CD from Microsoft .. Visual Studio 2005 Team Suite.

Please note that this is what windows update indicates on the web page
duplicate lines are on the web page .. not a copy and paste mistake.

SQL Server 2005 Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896) Tuesday, March 13, 2007 Microsoft Update
SQL Server 2005 Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896) Tuesday, March 13, 2007 Microsoft Update

LINK FOLLOWED
Installation Failure
Error Code: 0x652
Try to install the update again, or request help from one of the following resources

I include the logfile since it seems to convey useful informations to SQL Express experienced.

summary.txt logfile
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Time: 03/13/2007 12:28:02.906
KB Number: KB921896
Machine: somejunk
OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
/quiet
/allinstances
Cluster Installation: No

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Express Database Services (SQLEXPRESS) ENU SP2 2005.090.3042.00 x86 EXPRESS
Express Database Services (SQLExpress) ENU RTM x86 EXPRESS

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID

**********************************************************************************
Product Installation Status
Product : Express Database Services (SQLEXPRESS)
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_SharedTools
Error Number : 0
Error Description :
-
Product : Express Database Services (SQLExpress)
Product Version (Previous):
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_SQLEXPR.EXE
SQL Express Features : Client_Components,Connectivity,SDK
Error Number : 0
Error Description :
-

**********************************************************************************
Summary
Success
Exit Code Returned: 0

did you get the resolved? I'm haveing the same issue.

Sean

|||Me too. It continually tries to install although AFAIK it IS installed.
|||

No I did not get this resolved.

I suppose this creates uncertainty for me and perhaps others.

Please excuse my late reply.

|||

This has failed to install twice already this morning, and I've got a third Automatic Update message, which will probably be the same MS SQL Server trying and failing to install. This has been going on for at least a month--though not with multiple attempts in a day.

I wish I knew whether this was simply noise or whether it's something I should focus on, but characteristically, it's hidden behind opaque names and failure messages. I often feel like I don't own the computer I paid for; I'm simply maintaining it for MS.

|||I am having this same issue also - continuously tries to update but says it can't - any help out there?

jn|||

I'm having the same problem,

Has anybody been able to resolve this, its anoying the heck out of me?

Abe

|||Are you running ACT! on your computer? I am and it took an ACT! technician to get it resolved. It only took a full week of effort. LOL Yes I am serious a full week! One of the things you might try is uninstalling the SQL Server 2005 and then letting automatic update reinstall it. jn|||I uninstalled SQL Server 2005, reinstalled it and I am still having this problem. This is bad.|||

I got the same problem but got it resolved.
Apparently some of the ms sql server services (NOT any Express service) like SQL server active directory helper, and the sql server browser were disabled on my machine. I put them on an "Automatic" startup type and the update worked fine.

I hope it will help any of you.

Pieter

|||My automatic update of Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896) keeps failing and I do not even use SQL Server. How do I get rid of this nuisance?|||Following the advice of the previous posts I simply set the sql server express and sql browser services to manual start up and started the services (previously there were disabled and not running). Then I installed the service pack and it worked. Thankx for the advice.
|||

What version of ACT! are you running. I just installed ACT! 2007 and now have this issue. During the install, it corrupted .Net Framework 2.0 and SQL Server. Now all the other apps like QuickBooks, and OneCare Live don't operate the same.

Thanks,

JN2

|||

I am also running Act!2007(9) - I started having problems when auotmatic update tried to install the upgrade to version 9.0.1.162. The best thing for you to do is call Act and tell them you are having an installation problem. They'll give you free support for installation issues. That's what I did and they finally corrected the issue by having a technician take over my computer remotely. They had to make a lot of changes to the system files and then manually unistall ACT to get it worked out. Then I had to download the trial version of Act from their website - which is always the most current version - and re register it. It was VERY time consuming. Act techies worked on it for over 4 hours on 3 different occasions! Hopefully for you they have this figured out. Good luck.

|||

I feel your pain. I was on the phone with them (ACT Support) yesterday for 3hours 50minutes for the install. They crashed and deleted my .NET Framework, killed my security damaged QuickBooks (somehow) and then told me to call the other vendors to restore my data. I don't know why I put myself through so much pain with Sage.

Thanks for the reply on SQL Exp SP2. Today I have not received the update error warnings. But the day is young. Once I get a solution, I'll post it.

JN2

sql

Microsoft SQL Server 2005 Express Edition Service Pack 2 ..Failure

Please note that this is what windows update indicates on the web page
duplicate lines are on the web page .. not a copy and paste mistake.

LINK FOLLOWED
Installation Failure
Error Code: 0x652
Try to install the update again, or request help from one of the following resources

I include the logfile since it seems to convey useful informations to SQL Express experienced.

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID

**********************************************************************************
Summary
Success
Exit Code Returned: 0

did you get the resolved? I'm haveing the same issue.

Sean

|||Me too. It continually tries to install although AFAIK it IS installed.
|||

No I did not get this resolved.

I suppose this creates uncertainty for me and perhaps others.

Please excuse my late reply.

|||

|||I am having this same issue also - continuously tries to update but says it can't - any help out there?

jn|||

I'm having the same problem,

Has anybody been able to resolve this, its anoying the heck out of me?

Abe

I hope it will help any of you.

Pieter

Thanks,

JN2

|||

Thanks for the reply on SQL Exp SP2. Today I have not received the update error warnings. But the day is young. Once I get a solution, I'll post it.

JN2

Microsoft SQL Server 2005 Express Edition Service Pack 2 ..Failure

Please note that this is what windows update indicates on the web page
duplicate lines are on the web page .. not a copy and paste mistake.

LINK FOLLOWED
Installation Failure
Error Code: 0x652
Try to install the update again, or request help from one of the following resources

I include the logfile since it seems to convey useful informations to SQL Express experienced.

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID

**********************************************************************************
Summary
Success
Exit Code Returned: 0

did you get the resolved? I'm haveing the same issue.

Sean

|||Me too. It continually tries to install although AFAIK it IS installed.|||

No I did not get this resolved.

I suppose this creates uncertainty for me and perhaps others.

Please excuse my late reply.

|||

|||I am having this same issue also - continuously tries to update but says it can't - any help out there?

jn|||

I'm having the same problem,

Has anybody been able to resolve this, its anoying the heck out of me?

Abe

I hope it will help any of you.

Pieter

Thanks,

JN2

|||

Thanks for the reply on SQL Exp SP2. Today I have not received the update error warnings. But the day is young. Once I get a solution, I'll post it.

JN2

Microsoft SQL Server 2005 Express Edition Service Pack 2 ..Failure

Please note that this is what windows update indicates on the web page
duplicate lines are on the web page .. not a copy and paste mistake.

LINK FOLLOWED
Installation Failure
Error Code: 0x652
Try to install the update again, or request help from one of the following resources

I include the logfile since it seems to convey useful informations to SQL Express experienced.

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID

**********************************************************************************
Summary
Success
Exit Code Returned: 0

did you get the resolved? I'm haveing the same issue.

Sean

|||Me too. It continually tries to install although AFAIK it IS installed.
|||

No I did not get this resolved.

I suppose this creates uncertainty for me and perhaps others.

Please excuse my late reply.

|||

|||I am having this same issue also - continuously tries to update but says it can't - any help out there?

jn|||

I'm having the same problem,

Has anybody been able to resolve this, its anoying the heck out of me?

Abe

I hope it will help any of you.

Pieter

Thanks,

JN2

|||

Thanks for the reply on SQL Exp SP2. Today I have not received the update error warnings. But the day is young. Once I get a solution, I'll post it.

JN2

Wednesday, March 28, 2012

Microsoft SQL Management Studio failed to load

I am running SQL Server 2005 bata on my Windows Server 2003, web edition
machine. Recently got an error that the Bata had expired. I ignored this.
However, other C# apps using the Db started having problems.
Uninstalled .Net Framework Version 2. I downloaded the most
recent version from MS, installed the new version.
Now I can't run Management studio or the profiler. Get the following errors:
'Procedure entry point _CxxFrameHandler3 could not be located in the
dynamic link library MSVCR80.dll '
and a follow on error
..."\v2.0.50215\mscorwks.dll could not be loaded".
How do I get back to being able to use these tools?
Hi
The .NET versions are tightly linked to the SQL Server Betas.
Download the SQL Server September 2005 CTP and the Visual Studio 2005 RC1.
They are the newest and are a perfect match.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"FredC" <FredC@.discussions.microsoft.com> wrote in message
news:72539B05-013B-4A6C-BE1E-ED024A28247C@.microsoft.com...
>I am running SQL Server 2005 bata on my Windows Server 2003, web edition
> machine. Recently got an error that the Bata had expired. I ignored this.
> However, other C# apps using the Db started having problems.
> Uninstalled .Net Framework Version 2. I downloaded the most
> recent version from MS, installed the new version.
> Now I can't run Management studio or the profiler. Get the following
> errors:
> 'Procedure entry point _CxxFrameHandler3 could not be located in the
> dynamic link library MSVCR80.dll '
> and a follow on error
> ..."\v2.0.50215\mscorwks.dll could not be loaded".
> How do I get back to being able to use these tools?
|||Sql server 2005 CTP won't install here. It keeps asking me to insert
disk 2.
|||On Tue, 20 Sep 2005 08:59:05 -0700, "FredC"
<FredC@.discussions.microsoft.com> wrote:

>I am running SQL Server 2005 bata on my Windows Server 2003, web edition
>machine. Recently got an error that the Bata had expired. I ignored this.
>However, other C# apps using the Db started having problems.
>Uninstalled .Net Framework Version 2. I downloaded the most
>recent version from MS, installed the new version.
>Now I can't run Management studio or the profiler. Get the following errors:
> 'Procedure entry point _CxxFrameHandler3 could not be located in the
>dynamic link library MSVCR80.dll '
>and a follow on error
>..."\v2.0.50215\mscorwks.dll could not be loaded".
>How do I get back to being able to use these tools?
In addition to Mike's comments you need to be very careful about
uninstall order of components from the old SQL Server 2005 and .NET
Framework builds. That is described in some detail in the documents
that come with September CTP.
Andrew Watt
MVP - InfoPath
|||I found and downloaded SQL Server September 2005 CTP but I can't find Visual
Studio 2005 RC1. Where do I get it?
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> The .NET versions are tightly linked to the SQL Server Betas.
> Download the SQL Server September 2005 CTP and the Visual Studio 2005 RC1.
> They are the newest and are a perfect match.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "FredC" <FredC@.discussions.microsoft.com> wrote in message
> news:72539B05-013B-4A6C-BE1E-ED024A28247C@.microsoft.com...
>
>
|||Apologies microsoft, after all the things I've been saying about them.
All you do, is...
1. Install everything apart from SQL express, on the RC VS.Net 2005
1. put the "server" ISO on, install everything but the bottom checkbox.
1. put the "client" ISO on, install everything to run from the
harddrive.
1. Put the ISO VS.Net 2005 RC back on, and install the SQL Express.
Hey presto, it all works, including SQL express integrated into VS.Net.
(Now we can use SQL Express, with files, who is going to use Access?)
|||drawnai:
Thanks for the good info. But I got myself into more trouble. I thought I'd
try to uninstall Visual Studio and Sever. All the .Net stuff seems to
uninstall and the Server itself uninstalls, but tools like management studio
and profiler don't. They are in my start menu but not in add and remove
programs. Result is that Sever will not install the new tools. Got any
experience at get rid of this stuff while saving existing databases?
"drawnai@.hotmail.com" wrote:

> Apologies microsoft, after all the things I've been saying about them.
> All you do, is...
> 1. Install everything apart from SQL express, on the RC VS.Net 2005
> 1. put the "server" ISO on, install everything but the bottom checkbox.
> 1. put the "client" ISO on, install everything to run from the
> harddrive.
> 1. Put the ISO VS.Net 2005 RC back on, and install the SQL Express.
> Hey presto, it all works, including SQL express integrated into VS.Net.
> (Now we can use SQL Express, with files, who is going to use Access?)
>
sql

microsoft sql database (*.mdf) using help ?

I use visual std. 2005 and I create a asp.net web page after >add item> sql database > I added my project *.mdf file when I make project my project is runnig with visual studio 2005 but I sent my hostting (internet server )I cant use this mdf file . Are we register this mdf file sqlserver ? can we use this mdf file like access file (mdb ) . What kind of thing I do to use this mdf file .

Thanks

I know some hosts don't support SQL 2005, FastHosts in the UK for exampe have no plans to allow the user of the SQL Express MDF files so it cannot work like an Access MDB file. They say that this is down to performance and security implications.|||

prokurs:
Are we register this mdf file sqlserver ? can we use this mdf file like access file (mdb ) . What kind of thing I do to use this mdf file .

No, you must have a SQL instance on the host to use mdf files. Although in VS2005 you can create mdf files and use them by attaching them to a SQL Express Instance (specified in the Data Source property in your connection string), you still need a SQL Instance to which you have access. So you must have a SQL2005/Express instance on the hosting machine, and then add proper permissions to your account.

|||

hi can you look my mistake this mistake's source ishttp://www.prokurs.com/e/loginana.aspx you can enter this page after write random user name and passwors after then I have got a this mistake please help ?

Server Error in '/' Application.

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Data.SqlClient.SqlException: 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735091 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +820 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84 System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197 System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42 System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +83 System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160 System.Web.UI.WebControls.Login.AttemptLogin() +105 System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

|||

It is a connection failure, if you're using SQL2000 you need to make sure TCP/IP and Named Pipes network libraries are enabled on the SQL2000 instance via Server Network Utility; in case of SQL2005/Express you can enable the remote connecitons using SQL Server Surface Area. Then rewrite your connection string to point to the correct SQL instance.

If you're using built-in Login Controls (membership provider) in .NET 2.0, you can customize the database connections as mentioned in this article:

http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx

sql

Monday, March 26, 2012

Microsoft Please help-Web Service Problem

We had an app that called across to the web services to run batches of statements. Everything worked fine and now they stopped working. The report can still be ran from report manager. What things do we need to check to find the problem? Any help would be greatly appreciated.

Try turning on tracing and view the logs. Also see event viewer if there are any issues. It could be an issue with the app or connectivity instead of Reporting Services, since the web service is used to service Report Manager.

More info on logging.

http://msdn2.microsoft.com/en-us/library/ms156500.aspx

cheers,

Andrew

|||Thank you Andrew for your prompt response. We will look at the logs and see if that leads us in the right direction.|||

Some security patches were applied to the server in December. Is it possible that these could have messed with the way that authentication is handled?

Patches:

KB925398

KB925454

KB923689

KB911897

KB926247

KB923694

|||The app is getting the message back "The report server cannot open a connection to the report server database. A conection to the database is required for all requests and processing. SQL server does not exist or acess denied."|||Is it possible that any of these security patches could have messed with our authentication? Any suggestions Please.

Wednesday, March 21, 2012

Microsoft JDBC and SSL Support

What is Microsoft's plan for adding SSL support into their JDBC driver?
From what limited information I could find on the web, it appears
Microsoft has no plans to ever support it! If they are not going to
support it is there any way I can get the protocol definition so I can
begin developing a solution myself?
Am I even in the right place to ask such a question? Any Microsoft
employees here or is everyone here just a user and at the complete mercy
of Microsoft like I am?
Brett:
There are no plans to add SSL support to the current MS SQL Server 2000
Driver for JDBC. However, we do plan to have new driver for SQL Server 2005
and SSL on the feature list.
Shelby Goerlitz
Microsoft SQL Server
"Brett Prucha" <brett.prucha.bah@.scrb.navy.mil> wrote in message
news:MPG.1b8aba1c5bcc1515989680@.msnews.microsoft.c om...
> What is Microsoft's plan for adding SSL support into their JDBC driver?
> From what limited information I could find on the web, it appears
> Microsoft has no plans to ever support it! If they are not going to
> support it is there any way I can get the protocol definition so I can
> begin developing a solution myself?
> Am I even in the right place to ask such a question? Any Microsoft
> employees here or is everyone here just a user and at the complete mercy
> of Microsoft like I am?
|||Hi - regarding the new JDBC driver for SQL 2005. Is that planned to be
an upgrade to the current driver or a "new" driver as indicated by
your post?
- If new, will that driver be compatible with SQL 2000?
- Is there a beta version of the driver we can try with SQL 2005? We
have SQL 2005 Beta 2 but found no JDBC driver bundled there. When will
the SQL 2005 JDBC driver be available for beta testing with SQL 2005
please?
thanks
Grant
"Shelby Goerlitz [MSFT]" <shelbyg@.microsoft.com> wrote in message news:<#7N81DJhEHA.1048@.tk2msftngp13.phx.gbl>...[vbcol=seagreen]
> Brett:
> There are no plans to add SSL support to the current MS SQL Server 2000
> Driver for JDBC. However, we do plan to have new driver for SQL Server 2005
> and SSL on the feature list.
> Shelby Goerlitz
> Microsoft SQL Server
> "Brett Prucha" <brett.prucha.bah@.scrb.navy.mil> wrote in message
> news:MPG.1b8aba1c5bcc1515989680@.msnews.microsoft.c om...
|||Grant:
There isn't a beta version of the SQL Server 2005 driver to test yet, but as
soon as we know the timeline for this driver we'll post details to this
board.
-shelby
Shelby Goerlitz
Microsoft SQL Server
<grantmitchell7@.yahoo.com> wrote in message
news:fd5dcfa6.0408180917.412822f7@.posting.google.c om...
> Hi - regarding the new JDBC driver for SQL 2005. Is that planned to be
> an upgrade to the current driver or a "new" driver as indicated by
> your post?
> - If new, will that driver be compatible with SQL 2000?
> - Is there a beta version of the driver we can try with SQL 2005? We
> have SQL 2005 Beta 2 but found no JDBC driver bundled there. When will
> the SQL 2005 JDBC driver be available for beta testing with SQL 2005
> please?
> thanks
> Grant
> "Shelby Goerlitz [MSFT]" <shelbyg@.microsoft.com> wrote in message
news:<#7N81DJhEHA.1048@.tk2msftngp13.phx.gbl>...[vbcol=seagreen]
2005[vbcol=seagreen]
driver?[vbcol=seagreen]
mercy[vbcol=seagreen]

Monday, March 19, 2012

Microsoft Association rules importing to web form

I am using Microsoft association algorithm to find the association between PATIENT CITY > likely Disease. I like to know how can i import association model after creating from SQL Server BI studio to use in my ASP.NET web form? such a way when the user enters PATIENT CITY, system prompts associated Disease.

I do have Data mining with SQL Server 2005 book, could't find any resource for my objective.

Please suggest best source or tutorial how can i do

your help and insight is highly appreciated.

Raju

Please see Bogdan's suggestions on this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=650506&SiteID=1

Microsoft Analysis Services on the web problem

Hi All!

We are trying to implement a web solution which include some OLAP cubes. We are using the followings applications and components:

Server: Windows 2000 - Microsoft Internet Information Server - SQL Server 2000 - Microsoft Analysis Services

Client: Active X Cube Browser included with Office 2000 - Pivot Table Services

For access the cubes, we developed an ASP which includes the Active X, and connect to the Analysis Services server. If i access this web page from the server, i can view the cube, and use it without any problem, but if i try to access the cube accross internet, i am having the following problem:

"The operation requested failed due to security problems - the user could not be authenticated"

If you have any idea or suggestion about this problem, let me know.
Thanks!

IgnacioIt depends on the secuity mode you are using with SQL server most sane people wont let NT authentication through their firewall which leaves SQL logins only.

Try setting up the accounts to use SQL only authentication & see how you go.

Post back if probs

J.|||Thanks for your advice, but we already solve the problem.

We need to install SQL Server 2000 Enterprise Edition, because it has http connection and it works.

Thanks again,

Ignacio|||HII
Can u tell me what was the permissions in the cube.

1) if the cube gave has access to everyone . How did u restrict people on the network to access the cube.
2) if it was specific domain users. How did u manage to propagate security of a user accessing from the page.

Regds
Ram

Originally posted by isbampato
Thanks for your advice, but we already solve the problem.

We need to install SQL Server 2000 Enterprise Edition, because it has http connection and it works.

Thanks again,

Ignacio|||Ram,

we didn't configure a secure environment yet, because the cubes were prepared only for a demo in our intranet. We have created a test database, and a test set of cubes, and added a new user only for use in this test environment, and with full control over it.

Besides, we added basic web authentication to the web page with the online cubes.

We didn't analyze yet how to secure this because it's still at a test phase.

Best regards,

Ignacio

Wednesday, March 7, 2012

Messed up with reporting services

Hi, I'm developing a Web application in which the user, after a certain operation, it will generate a report using reporting services. The doubt is:

How do I generate the report?Is there any report on the web app that I give parameters and then show it, or is there a report on the web server and I send him the parameters?These parameters come from a specific data set or can come from a arraylist ore something from the web app?

Which of the two perspectives is the best?I've looked im Microsoft but this aspect is not very explicit, I'm having serious doubts about how to do this, its kinda complicated one I'm brand new on SSRS!Thanks a lot!!

With reporting services you can access reports 2 ways (thatI know of)

URL access, using this method your eb app will build up a url for eg,http://reportServerName//reportserver/reportdirectory/reportname.rdl

to pass parameters, you can add &Parameter1Name=1&ParameterName2=2 etc

you can also build up your url to hide/show toolbars, select output formats, etc

Web service, basically the above but programatically

If you have them check out Reporting Services BOL looks of good info there

Saturday, February 25, 2012

Message: Missing end comment mark '*/'.

Hi,

I created a web syncronization merge replication ,both servers and clients are sql server 2005 and everything is fine with the settings , but while synchronization and after i received some sch files i got the following message at the subscribers on the initial snapshot operation:

2006-06-27 07:50:14.471 The schema script 'myfile_311.sch' could not be propagated to the subscriber.
2006-06-27 07:50:14.471 Category:NULL
Source: Merge Replication Provider
Number: -2147201001
Message: The schema script 'myfile_311.sch' could not be propagated to the subscriber.
2006-06-27 07:50:14.471 Category:NULL
Source: Microsoft SQL Native Client
Number: 113
Message: Missing end comment mark '*/'.

Any idea ?

Tarek Ghazali

SQL Server MVP

My guess is that myfile_311.sch contains a stored procedure|view|function with something like

...

There is a longstanding limitation in our batch parsing logic that will erroroneously recognize 'go's embedded in comments to be batch delimiters. The only workaround for this is to edit the script generated by the snapshot agent to remove the offending comment. We really hope that we can address this issue in the near future.

-Raymond

Friday, March 30, 2012

Microsoft SQL Server client license costs

Microsoft SQL Server client license costs

Microsoft SQL Server 2005 performance

Microsoft SQL Server 2005 Express Edition Service Pack 2 ..Failure

Microsoft SQL Server 2005 Express Edition Service Pack 2 ..Failure

Microsoft SQL Server 2005 Express Edition Service Pack 2 ..Failure

Microsoft SQL Server 2005 Express Edition Service Pack 2 ..Failure

Wednesday, March 28, 2012

Microsoft SQL Management Studio failed to load

microsoft sql database (*.mdf) using help ?

Server Error in '/' Application.

Monday, March 26, 2012

Microsoft Please help-Web Service Problem

Wednesday, March 21, 2012

Microsoft JDBC and SSL Support

Monday, March 19, 2012

Microsoft Association rules importing to web form

Microsoft Analysis Services on the web problem

Wednesday, March 7, 2012

Messed up with reporting services

Saturday, February 25, 2012

Message: Missing end comment mark '*/'.

Merging two dbs

Blog Archive

About Me