Showing posts with label license. Show all posts
Showing posts with label license. Show all posts

Sunday, March 25, 2012

Can I edit SDF files without full SQL Server license?

I'm trying to open an SDF file. After many searches on the net, it appears that there are two ways to do this:

Open the file in VS 2005 Open the file in SQL Server Management StudioI don't have, and don't plan to purchase, a license to full SQL Server 2005. I do have Visual Studio 2005 Pro. When I open an SDF file in Visual Studio, I get the following (oh so informative) error:

The operation could not be completed. Unspecified error

Since I don't have full SQL server, I downloaded SQL Server Management Studio Express. There's one major problem: the Server type combo box is disabled in the "Connect to Server" dialog. Try as I might, I can find no mention anywhere as to why this is the case. I'm guessing that functionality isn't supported in the Express version of the tool, but as far as I can tell, nobody thinks it might perhaps be reasonable to document why this combo box is disabled. It certainly doesn't show up in the document that shows up when I click the help button on this dialog.

Could somebody at Microsoft please tell me if it is even possible to edit these files without buying a full SQL Server license? I'm trying to use SQL Server Compact Edition to replace legacy code that uses an MDB file (via ADO) for a desktop application. From everything I have read, this is the officially recommended thing to do. But if I now have to buy a full SQL Server lincense to accomplish what used to be a simple double click on an MDB file, then there's something seriously wrong.

It turns out that my problem was the fact that I didn't have Service Pack 2 installed for SQL Server Management Studio Express, although installing that (along with making sure everything else on my system was up-to-date via Microsoft Update) didn't solve the Visual Studio error. I do have SP 1 installed for VS 2005.
sql

Thursday, March 22, 2012

Can I Deploy a report to a client who doesn't have SQL server license.

How can I Deploy a report with my visual Studio.Net application to a company
who doesn't have SQL server license?
I plan to use SQL Server 2005 Express.SQL Server Express does not yet have support for this. Supposedly Q1. Then
the data needs to reside locally as well.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Roberto Hernández" <robertohh@.newsgroups.nospam> wrote in message
news:%23uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl...
> How can I Deploy a report with my visual Studio.Net application to a
> company who doesn't have SQL server license?
> I plan to use SQL Server 2005 Express.
>|||VS2005 provide a report viewer control which allow you to render reports.
does your application is web or windows based?
"Roberto Hernández" <robertohh@.newsgroups.nospam> wrote in message
news:%23uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl...
> How can I Deploy a report with my visual Studio.Net application to a
> company who doesn't have SQL server license?
> I plan to use SQL Server 2005 Express.
>|||Hi Roberto,
As Bruce mentioned, the SQL Server reporting service is not available for
EXPRESS edition so far. Also, what's your application's detailed structure,
does it require a local SQL Server instance? If it is just a client
application which can consume reporting service reports through those
remote accessible programming interfaces, we can consider separate the
application from the backend SQL Server database... Thus, there need a
certain DataBase server which have SQL Server 2005 instance installed
already...
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: "Jéj? <willgart@.BBBhotmailAAA.com>
| References: <#uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl>
| Subject: Re: Can I Deploy a report to a client who doesn't have SQL
server license.
| Date: Thu, 26 Jan 2006 21:35:45 -0500
| Lines: 12
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| X-RFC2646: Format=Flowed; Response
| Message-ID: <emzDhpuIGHA.424@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: modemcable008.41-80-70.mc.videotron.ca 70.80.41.8
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67651
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| VS2005 provide a report viewer control which allow you to render reports.
| does your application is web or windows based?
|
| "Roberto Hernández" <robertohh@.newsgroups.nospam> wrote in message
| news:%23uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl...
| > How can I Deploy a report with my visual Studio.Net application to a
| > company who doesn't have SQL server license?
| >
| > I plan to use SQL Server 2005 Express.
| >
|
|
||||RDLC reports doesn't required any server.
its standalone reports generated on the client side, not the server side.
Also, I think that the report control can render RDL reports without using a
reportserver.
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:TUqDfawIGHA.1236@.TK2MSFTNGXA02.phx.gbl...
> Hi Roberto,
> As Bruce mentioned, the SQL Server reporting service is not available for
> EXPRESS edition so far. Also, what's your application's detailed
> structure,
> does it require a local SQL Server instance? If it is just a client
> application which can consume reporting service reports through those
> remote accessible programming interfaces, we can consider separate the
> application from the backend SQL Server database... Thus, there need a
> certain DataBase server which have SQL Server 2005 instance installed
> already...
> 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: "Jéj? <willgart@.BBBhotmailAAA.com>
> | References: <#uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl>
> | Subject: Re: Can I Deploy a report to a client who doesn't have SQL
> server license.
> | Date: Thu, 26 Jan 2006 21:35:45 -0500
> | Lines: 12
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> | X-RFC2646: Format=Flowed; Response
> | Message-ID: <emzDhpuIGHA.424@.TK2MSFTNGP12.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: modemcable008.41-80-70.mc.videotron.ca 70.80.41.8
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:67651
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | VS2005 provide a report viewer control which allow you to render
> reports.
> | does your application is web or windows based?
> |
> | "Roberto Hernández" <robertohh@.newsgroups.nospam> wrote in message
> | news:%23uQARosIGHA.1760@.TK2MSFTNGP10.phx.gbl...
> | > How can I Deploy a report with my visual Studio.Net application to a
> | > company who doesn't have SQL server license?
> | >
> | > I plan to use SQL Server 2005 Express.
> | >
> |
> |
> |
>

Monday, March 19, 2012

Can I buy 1 per seat license if I have 20 users login using same i

Hi,
May I know can I just buy 1 per seat license if I have 20 users login using
same id? If I have misunderstood this per seat license concept, pls highligh
t
to me.
Thanks
andrewNo. A seat does not correspond to a login id.
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.masterado.net/home/listings.aspx
"andrew" <andrew@.discussions.microsoft.com> wrote in message
news:161927B9-FBEE-405F-B869-3DA69522B237@.microsoft.com...
> Hi,
> May I know can I just buy 1 per seat license if I have 20 users login
> using
> same id? If I have misunderstood this per seat license concept, pls
> highlight
> to me.
> Thanks
> andrew|||Besides, per Seat was last available only on SQL Server 7.0. Now, your only
options are CAL based on per user or per device or per processor. This has
nothing to do with concurrent connections.
Sincerely,
Anthony Thomas
"Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
news:u51B5$uKFHA.2284@.TK2MSFTNGP10.phx.gbl...
No. A seat does not correspond to a login id.
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.masterado.net/home/listings.aspx
"andrew" <andrew@.discussions.microsoft.com> wrote in message
news:161927B9-FBEE-405F-B869-3DA69522B237@.microsoft.com...
> Hi,
> May I know can I just buy 1 per seat license if I have 20 users login
> using
> same id? If I have misunderstood this per seat license concept, pls
> highlight
> to me.
> Thanks
> andrew

Can I buy 1 per seat license if I have 20 users login using same i

Hi,
May I know can I just buy 1 per seat license if I have 20 users login using
same id? If I have misunderstood this per seat license concept, pls highlight
to me.
Thanks
andrew
No. A seat does not correspond to a login id.
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.masterado.net/home/listings.aspx
"andrew" <andrew@.discussions.microsoft.com> wrote in message
news:161927B9-FBEE-405F-B869-3DA69522B237@.microsoft.com...
> Hi,
> May I know can I just buy 1 per seat license if I have 20 users login
> using
> same id? If I have misunderstood this per seat license concept, pls
> highlight
> to me.
> Thanks
> andrew
|||Besides, per Seat was last available only on SQL Server 7.0. Now, your only
options are CAL based on per user or per device or per processor. This has
nothing to do with concurrent connections.
Sincerely,
Anthony Thomas

"Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
news:u51B5$uKFHA.2284@.TK2MSFTNGP10.phx.gbl...
No. A seat does not correspond to a login id.
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.masterado.net/home/listings.aspx
"andrew" <andrew@.discussions.microsoft.com> wrote in message
news:161927B9-FBEE-405F-B869-3DA69522B237@.microsoft.com...
> Hi,
> May I know can I just buy 1 per seat license if I have 20 users login
> using
> same id? If I have misunderstood this per seat license concept, pls
> highlight
> to me.
> Thanks
> andrew

Can I buy 1 per seat license if I have 20 users login using same i

Hi,
May I know can I just buy 1 per seat license if I have 20 users login using
same id? If I have misunderstood this per seat license concept, pls highlight
to me.
Thanks
andrewNo. A seat does not correspond to a login id.
--
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.masterado.net/home/listings.aspx
"andrew" <andrew@.discussions.microsoft.com> wrote in message
news:161927B9-FBEE-405F-B869-3DA69522B237@.microsoft.com...
> Hi,
> May I know can I just buy 1 per seat license if I have 20 users login
> using
> same id? If I have misunderstood this per seat license concept, pls
> highlight
> to me.
> Thanks
> andrew|||Besides, per Seat was last available only on SQL Server 7.0. Now, your only
options are CAL based on per user or per device or per processor. This has
nothing to do with concurrent connections.
Sincerely,
Anthony Thomas
"Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
news:u51B5$uKFHA.2284@.TK2MSFTNGP10.phx.gbl...
No. A seat does not correspond to a login id.
--
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.masterado.net/home/listings.aspx
"andrew" <andrew@.discussions.microsoft.com> wrote in message
news:161927B9-FBEE-405F-B869-3DA69522B237@.microsoft.com...
> Hi,
> May I know can I just buy 1 per seat license if I have 20 users login
> using
> same id? If I have misunderstood this per seat license concept, pls
> highlight
> to me.
> Thanks
> andrew