|
i need your help please help me ,,
actually i have developed a windowd service in c#.net , this service retrieves data from a sql server installed on a work group on the same lan wherre my computer resides , but it gives an exception always " login failed for user sa reason cannot connect to a trusted sql server connection. " remote sql server is configured for both windows and sql server authentication and i have configured serverprocess installer for local system account with user name password = null ;
kindly help me
tauseef
hello
|
|
|
|
|
Your service is running under the Local System account, but in your connection string your specifying Trusted Connection. You can't do that since the Local System account is not trsuted by the SQL Server, and can't be. Remove the Trusted Connection part of your connection string, but still supply an SQL username and password to use. DO NOT USE THE 'SA' ACCOUNT! Create a seperate account to be used by the service for this database.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hi thanks for your cooperation , i have created a seperate user on sql server with the name "terminal" and passowrd "abc"
i am supplying the following connection string
"Provider=sqloledb;Data Source=software-14;Initial Catalog=company071;;integrated security=SSPI;User Id=terminal;Password=abc;";
kindly tell me where i am wrong , is there any need to create a windows nt user on the pc where sql service resides .
i m getting the following exception
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection
hello
|
|
|
|
|
Remove the Integrated Security junk. This is what's causing your "trusted connection".
Provider=sqloledb;Data Source=software-14;Initial Catalog=company071;User Id=terminalassword=abc;
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
thaksn again
but dear this time it gives this exception
Login failed for user 'terminal'. Reason: Not associated with a trusted SQL Server connection.
my connection string is
"data source = software-12;initial catalog = company071;user id=terminal;passowrd=abc"
hello
|
|
|
|
|
Did you copy/paste this connection string or just type it into this post??
If you're using the SqlConnection object, it should be:
"Data Source=software-12;Initial Catalog=company071;User Id=terminal;Password=abc"
This will work so long as you've created a user id terminal and assigned it the appropriate permissions to the company071 database. This means, at a minimum, giving that user db_datareader and db_datawriter roles in your database.
Also, when you created the user, did you turn on SQL Server authentication for it?
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
No i just typed this string here , my this service works fine of i provide my local system sql server in connection string,even i give trusted connection = true in the case of local sql server ...so connection string is working fine .
Thanks for yoru cooperation
on other side let me tell you how i crearted a user.
Enter prise manager i select my locar server , go into security >logins
>in this window >right click >i provided in the name text box "terminal"
i checked sql server authentication > i provided password>i selected master as dafault data base> lanuguage English>than Server Roll TAB>i checked only system administrator>
>than TAB database access > i selected Company071>in the window belowe for company07 roles > i checked public and db_owner>at the end a password confirmation window open and retype the passowrd for this login...
Now i am in company 07d1 databsase>i select logins> now here is a login of terminal>
i open its properties>public and dbowner fields are already checked>now i click permission button>and i select the "Employee"table >now i press columns buttons > here i check the necessery columns for htis user > click ok and finich every thing is fine, in query analyzer results are perfect, this user can access the data base company071 tables employee
hello
|
|
|
|
|
The default database is not master. It should be Company071.
Other than that, I can't see what you did wrong. Either there's something you're not telling me, or there something you are telling me that's not been verified as being true.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
We r working on a project in which we have to control the video device attached to the PC and want to get live video stream to be displayed in our windows application.PLZ help us.......
khalid mahmood
|
|
|
|
|
We r working on a project in which we have to control the video device attached to the PC and want to get live video stream to be displayed in our windows application.PLZ help us.......
khalid mahmood
khalid mahmood
|
|
|
|
|
How to count users logged in the terminal server ?
Thanks
-- modified at 13:21 Friday 29th September, 2006
|
|
|
|
|
what server is it
just windows or iis
|
|
|
|
|
I'm looking for a way to persist (or at least serialise) all the properties of a Control, in particular a DataGridView. I would like to emulate the MS Access feature, where if I change, for instance, a column width at run time, the grid retains the new width for future sessions.
I could hard-code only certain properties, such as column width, but I'm busy setting up a prototype project that allows me to play with many properties at runtime and immediately see the effects of my changes. I would like to preserve configurations I prefer for use in production scenarios.
I could do this with reflection, but that's a bit more involved than I want to get right now.
|
|
|
|
|
Hi,
We are using Windows 2003 server on our server with IIS 6.0, my doubt is in that server we already have web sites created using .Net version 1.1, now recently we are going to upload an site with .Net version 2.0, is there any thing to be changed in the server regarding version??? else it will work well with out changing
Know is Drop, Unknown is Ocean
Know is Drop, Unknown is Ocean
|
|
|
|
|
You have to create at least one separate application pool for your .NET 2.0 applications. An application pool uses a single (pool of) worker processes, W3WP.EXE. A process can only load one version of the .NET CLR in its lifetime. If they share a pool, whichever version of the framework loads first will be the only version running in that pool. This can cause .NET 2.0 applications to fail if they end up running on 1.1 or vice versa.
|
|
|
|
|
Does anyone know of a good/usable .net iCal parser?
Mark
|
|
|
|
|
How can i bind dynamic dataset(with varing number of columns) to crystal report?
thank you
hmcu
|
|
|
|
|
Dim MyReport As ReportDocument = ...Assign ur ReportName...
Dim MyDataSet as New DataSet
...Fetch data to MyDataSet...
MyReport.Database.Tables(0).SetDataSource(MyDataSet)
"I firmly believe that
any man's finest hour,
the greatest fulfillment of all that holds dear,
is that moment,
when he has worked his heart out in a good cause
and lies exhausted in the field of battle - victorious..."
|
|
|
|
|
my Problem is the dataset contains varying number of data columns. it will define @ run time.i want to create the report acccording to that dataset.
|
|
|
|
|
Hi all!
I'm writing a program where I need to make some drawings over previously created
in-memory Metafile. The very first drawing succeeds but next time I'm trying to
call Graphics.FromImage on same metafile object OutOfMemoryException is being thrown.
Can anyone say me, what exactly happens?
Thanks a lot.
P.S. Please excuse me for my poor English.
<br />
Metafile meta = null;<br />
MemoryStream mstream = new MemoryStream();<br />
<br />
using (Graphics gr = CreateGraphics())<br />
{<br />
IntPtr attribDc = gr.GetHdc();<br />
meta = new Metafile(mstream, attribDc);<br />
gr.ReleaseHdc(attribDc);<br />
}<br />
using (Graphics gr = Graphics.FromImage(meta)) <br />
{<br />
m_Visualizer.DrawTemplateMnemo(m_Template, gr);<br />
}<br />
using (Graphics gr = Graphics.FromImage(meta))
{<br />
m_Visualizer.DrawTemplateMnemo(m_Template, gr);<br />
}<br />
|
|
|
|
|
Does anybody know how to use OpenGL with .Net forms application in Visual C++ environment or any place I can take a look?
Thanks.
|
|
|
|
|
Hi,
I have a simple problem that I am trying to solve for the past 2 days.
I have an application in system that is basically a MFC application and for a module it does CLR hosting and then on it runs .NET code. I am trying to attach my .NET code to it but at the instant when I attach the app.exe to my code, it gives an error message with just the words "UNABLE TO ATTACH TO THE PROCESS". Whereas am able to do the same thing in another system.( a WIN 2000 machine but mine is XP 
Not sure if this is due to some OS problem or some security tweak that is missing in my system or something to do with CLR hosting.
Thanks,
Mani
|
|
|
|
|
<br />
using System;<br />
using System.Threading;<br />
using System.Windows.Forms;<br />
<br />
static class Program1<br />
{<br />
[STAThread]<br />
static void Main()<br />
{<br />
Thread.Sleep(5000);<br />
Application.Run(new Form());<br />
}<br />
}<br />
Sleep simulates assemblies loading.
If I run this program and open the Visual Studio menu before the form appears the program does not appear in the taskbar. This happens always and I can live with it.
But an ugglier thing is that if I switch to another program before the form appears sometimes Program1 does not appear in the taskbar but you can go to it with Alt+Tab or by minimizing the other programs' windows.
Does somebody know if this is a Windows or .NET bug and what can I do to avoid this?
|
|
|
|
|
If I understand you properly, the TaskBar icon won't show up until the form does?? That's correct, it shouldn't, not until the form appears. The icon won't exist until the form is instantiated and it's message pump is running.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
The taskbar icon does not show up at all (neither after the form appears). You can wait a week and it still does not show up.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
