› Forums › Operating Systems › Windows Server 2008 R2 › Miscellaneous › Unique security issue across my network using SQL 2005
- This topic has 17 replies, 2 voices, and was last updated 13 years ago by
MarcusTaz.
- AuthorPosts
-
- 26th September 2010 at 15:33 #44076
First off this is my first post and I want to thank all the creators and their hard work. I have been using Server 2008 workstation for some time now but I needed to format due to reg issues and I fiqured why not upgrade to R2 and take advantage of the latest and greatest.
I use my Server primarily as a Home Media Server to deliver all my video content across a program caled My Movies, http://www.mymovies.dk/ to all my Windows 7 clients on my network. My Movies i’ll refer to as MM catologs my video collection in a SQL 2005 DB and this is where my problem lies. With Server 2008 I did not have this connection issue but with R2 I cannot seem to get the clients to connect without adding an account on the server that matches the client. Again the issue is my clients cannot connect to the MM database unless I make a local account on the R2 server that matches that of the client. Also I have to add a password to the client machine which really complicates the simplicity of connecting to MM just to play a movie! Without that specific account I cannot connect, so I know it is a security issue R2 side but I cannot fiqure out what setting to lax or turn off and that is why I am asking for help.
Thank in advance.
- 26th September 2010 at 19:00 #50920
Can anyone with server experiance help, please?
- 26th September 2010 at 22:41 #50921
Have you tried changing the Authentication mode from Kerberos to NTLM?
1. In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.
2. On the Security page, under Server authentication, select the new server authentication mode, and then click OK.
3. In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to restart SQL Server.
Courtesy: http://msdn.microsoft.com/en-us/library/ms188670.aspx
See if that helps.
- 26th September 2010 at 23:43 #50922
Thank you for the responce.
Under the authentication type I have 2 choices;
Windows Authentication Mode
SQL Server and Window Authentiation Mode
SQL Server and Window Authentiation Mode was selected by default. Changing it to just the
Windows Authentication Mode made no change. Also I never had to do this with Server 2008 and I am not sure what MS has changed in terms of security from 08 to 08R2 to give this issue. I am certainly far from being an expert in this dept.Thank you again and please any more advise. I really do not want to go through another format and reinstall of all my porgrams and settings. 😕
- 27th September 2010 at 00:38 #50923
You could type the error code here on the forum that it displays when you try to authenticate using credentials from the client machine?
- 27th September 2010 at 00:54 #50924
I have Server 2008 and I exported the Local Security Policy settings from my machine in the attachment below. Just extract the .zip and the security template (.inf) is in there.
1. Go to Start > Administrative Tools > Local Security Policy
2. In Local Security Policy, go to Action > Import Policy…
Navigate to the location where you saved server2008securitytemplate.inf and import it into your machine. Your machine will now be matched with the same local security policy as 2008 hopefully this will work. Probably not but worth a shot. I’m no expert myself just offering us what I can bring to the table. Atleast we’ll be able to use a process of elimination to figure out what is causing this. Maybe its a read/write issue? When you ported to R2 did you take ownership of any specific folders which might be prohibiting the connection?
- 27th September 2010 at 00:56 #50925
The best way I can show you is the attached img…
MyMovies has a client version and a Server version. The server version installs a light version of My SQL 2005. My Movies interacts with Windows Media Center and creates it own strip within it. When WMC is launched and the strip selected you can see all your movies/videos and then select and play them from the strip.
- 27th September 2010 at 00:57 #50926
Ok will give it a shot and get back to you ASAP.
Thanks!
- 27th September 2010 at 01:02 #50927
TCP Port 1433: Microsoft SQL Server port used typically for remote connections to the database.
Do you have TCP port 1433 forwarded on your router? When you re-installed the OS your private IP address (192.168.x.x) probably changed and its not matching the one you put in router. For example if you IP address in 2008 was 192.168.0.2 and you forwarded port 1433 to 192.168.0.2, in R2 it will not work because your address might be something other than 192.168.0.2.
- 27th September 2010 at 01:12 #50928
Actually after the format the local IP 192.168.1.x stayed the same. I never had to forward any ports in the router. The only thing MM tells you to do it for allow 2 .exec through the firewall, but even if I disable the firewall completely both private and public I still cannot connect so I do not think it is a port issue. Sadly your security policy did not work. 🙁
- 27th September 2010 at 01:21 #50929
Yeah I didn’t think it had anything to do with a firewall issue because you are staying inside your internal network (intranet) and thus port forwarding is not necessary.
I was reading on this forum relating to your issue and here’s what someone had to say:
“I followed the steps above, but still had no luck connecting a clients to the server. I looked at the sharing properties for the “FileStorage” share and noticed that “Users” was not listed under “People to share with” list. I tried adding it, but it wouldn’t take. So, I added “Everyone” with read/write privelages, and BAM! ITS WORKING!!!!”
I don’t have the program installed so if you know where the heck the “FileStorage” share folder is, trying adding the “Everyone” group read and write permissions and see if that fixes it.
- 27th September 2010 at 01:59 #50930
Yea not really sure, still tryingto find the share you are talking about, got a link? What a pain in the neck.
- 27th September 2010 at 02:08 #50931
I found shares and MM is one of them out of the programdata older and everyone is already in the list so no go there…
- 27th September 2010 at 02:18 #50932
Just out of curiosity what happens when you change the name of your computer from mediaserver-pc to something like Marcus-PC? Did you have the same exact hostname on 2008 as you have in R2 currently?
So much hassle lmfao and they say R2 is better. Not necessarily. I’ve had nothing but problem with R2 and will never go back to it. Praise 2008!
- 27th September 2010 at 02:36 #50933
I am sorry bro, I had it, the kids are going to want to watch their movies tomorrow, 2 and a 3 year old and they are hooked on Tinkerbell, lol… I have had it, I have messed with this thing all weekend and wasted nothing but time. I am currently installing Windows 7 64 bit just to give it a try and see if it has the same issue. If it does I have a backup img of my server 2008 install and I will just revert back. Really the main issue that made me switch in the first place is I could not get Verizon Media Manager installed properly on server 2008. I had an earlier version of it installed and running but I cannot get the new version to run. Man oh man computers, sometimes I want to take all of them in my driveway put’em in a pie and break out the lighter fluid…
I’ll post back and let you know the results. Thanks again for all your time and help.
- 27th September 2010 at 03:13 #50934
Ok Win 7 worked out of the box by using the HomeGroup feature. Now I can access the server with all the clients… Going to miss server, one day if I am really bored I may bang my head again. 😯 😆
Thank again for trying to help man. Take care.
- 27th September 2010 at 07:01 #50935
Windows Home Server V2 is based off Server 2008 R2’s core maybe you can get “My Movies” to work on WHS and centralize all your media data to a true server which might simplify everything for you in the future.
- 27th September 2010 at 13:01 #50936
For sure I will check it out. I tried V1 and really did not care for it being it was based off the old 2003 core. Reminds me to much of XP 😆 and really I wanted the better file tranfer speeds you get with the new OS compared with the old OS’… I will have to grab a copy of the beta and check it out, thanks again for all your help.
PS: at least V2 will have homegroup option for n00bs like me 🙂
- AuthorPosts
- You must be logged in to reply to this topic.